SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5

SQL Full Course Playlist ?
https://www.youtube.com/playlist?list=PLdOKnrf8EcP17p05q13WXbHO5Z_JfXNpw

Like, Share & Subscribe Now :)
⭐ Subscribe for more SQL tutorials like this: https://bit.ly/3Fc7Gc6

➖➖➖➖➖➖➖➖➖➖➖➖➖
Timestamps:
00:00 Intro
00:06 SELECT Statement in SQL
02:16 Where Clause in SQL
03:15 Operators in SQL
05:45 LIMIT Clause & ORDER BY Clause in SQL

➖➖➖➖➖➖➖➖➖➖➖➖➖
Queries used:

? Customer Table

CREATE TABLE customer
(
CustID int8 PRIMARY KEY,
CustName varchar(50) NOT NULL,
Age int NOT NULL,
City char(50),
Salary numeric );

INSERT INTO customer (CustID, Custhame, Age, City, Salary)
VALUES
(1, ‘sam’, 26, ‘Delhi’, 9008),
(2, ‘Ram’, 19, ‘Bangalore’, 11000),
(3, ‘Pam’, 31, ‘Mumbai’, 6060),
(4, ‘3am’, 42, ‘Pune’, 10000);


? Classroom Table

CREATE TABLE classroom (
rollno int8 PRIMARY KEY,
name varchar(50) NOT NULL,
house char(12) NOT NULL,
grade char(1) );

INSERT INTO classroom (rollno, name, house, grade)
VALUES
(1, ‘Sam’, ‘Akash’, ‘B’),
(2, ‘Ram’, ‘Agni’, ‘A’),
(3, ‘Shyam’, ‘Jal’, ’B’),
(4, ‘Sundar’, ‘Agni’, ’A’),
(5, ‘Ram’, ‘Yayu’, ‘B’);

➖➖➖➖➖➖➖➖➖➖➖➖➖

Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1
https://www.youtube.com/watch?v=yH1zCq-iaeU

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2
https://www.youtube.com/watch?v=HmH-76_2Ak8

Create Table In SQL & Create Database | SQL Tutorial In Hindi 3
https://www.youtube.com/watch?v=v-2cIUgx_jw

INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4
https://www.youtube.com/watch?v=4YAAgrm8_ZI

➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:

Instagram: https://www.instagram.com/rishabhnmishra/
LinkedIn: https://www.linkedin.com/in/rishabhnmishra/
Twitter: https://twitter.com/rishabhnmishra

➖➖➖➖➖➖➖➖➖➖➖➖➖

If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!