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

Показать описание

SQL Full Course Playlist 👇

Like, Share & Subscribe Now :)

➖➖➖➖➖➖➖➖➖➖➖➖➖
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

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2

Create Table In SQL & Create Database | SQL Tutorial In Hindi 3

INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

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

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

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!

Рекомендации по теме

Комментарии

understood in single watch, need more teachers like you. keep posting. I am subscribing.

mayureshkulkarni

Please Provide Advance Excel full course for Data Analyst.

ankitjadon

Best videos for SQL and I've never seen it before

ataulmohsin

Sir you explanation is so easy hai ❤❤❤❤❤❤❤

memesmaster

Thanks for such a wonderful tutorial ❤ love from Pakistan

abdulmoiz_

Great way of teaching and making things easy to understand ❤❤

rithikahuja

good video sir, mai non technical se hu sql practice ke liye kya kare

mayurgawali

Great Job. I think this video series is very useful to brushup the SQL topics before the interview.

vikramarora

Learning from Bangladesh ❤
U r a great teacher

tasmin-jahan

Thank you for the whole sql series. Never thought i would actually be able to understan sql. Your manner of explaining is simple yet exceptional:)

suchitasharma

very amazing, thank you very much from bottom to my heart.

CWofLearning

after created a table how can i change the number of character of a datatype in a column ?

urfashionguider

Thanks for the great videos. Can you please also create videos on performance tuneing?

meghamisra

when we are used limit clause before that we arrenged data in asc order so when we aplay a limit of 5 in this we 1 name is barbara but your out put is different

gangstergemar

Sir I am really enjoying this playlist but as you mentioned in the title that this Tutorial is for Beginner's so apart from this playlist is there anything that we have to learn from our own or you are going to upload videos on Advanced SQL or something? And thank you soo much sir for providing this amazing Tutorial

AjitSinghDataScience

sir truncate table n kare only drop table kare to table hi delete hogi ki record bhi delete hoga?

chandanichhablani

Nice job sir, can you please share the ppt with us

KapilKumar-oghz

Great work sir❤, i had to give Double quotes while accessing columns name how to fix it can u tell?

dhaleswarpatel

sir i am a final year student of Mtech in iit kgp and my placement session is almost start your way of teaching are best so i want to complete SQL from you but placement also came so how much time it will take to complete this SQL series? these is helpful for me. and thank you very much for this valuable content and teaching style.

kamleshrathor

Sir mere laptop mein ye postgre sql lag kar raha... It's not working properly.. Plz suggest me any other DBMS 😊

Altaf_Alam

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

5 Basic SELECT Statement Queries in SQL

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

SQL Server Express 2008 R2 Tutorial 5 - Select Statement Where Clause

SQL Where Clause

MySQL Select Query with Where Clause Complete Tutorial

How to Filter with the WHERE clause in SQL

where clause in sql | oracle database

11. Where Clause in Select Statement in SQL Server Step by Step

SQL SELECT statement WHERE clause

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

Oracle SELECT Statement and WHERE Clause | Oracle Tutorials for Beginners

SQL Lesson #2: Simple SELECT Statement with a WHERE clause and CONCATENTATION

The SQL Server SELECT statement in 60 seconds - the WHERE Clause #shorts

Sql server select where in list

SELECT query in SQL - Retrieval of records from a table

How to Combine the result sets of 2 or more SELECT statements in SQL With Where Clause | #SQLUnion

Where Clause In Select Statement In MySQL

Select Statement in MySQL | Beginner MySQL Series

My SQL Beginner Tutorial | Select Statement | Where Clause | Group By + Having | Order By + Limit

04 Where Clause in Select Statement

Master the SQL SELECT statement part 02: WHERE clause

SQL Select statement with where clause | sql query to retrieve data from Tables

SQL, select statement and where clause, lesson 18

03,Select statement,Where Clause,AND,OR, operator,MySql,for beginners,Computer,IP