How to use where clause in SQL | SQL Query | Learn filtering data in SQL from Excel
Where Clause is used in SQL queries to filter data based on certain conditions. While working with character data type, one needs to use Like Operator in SQL query. However, for integer data types, operators such as And, Or are used.
There are several questions asked in interviews on where clause for different roles such as data analyst, Jr. Data scientist, Business Analysts etc.
Check out these Links :
1. Website : www.youranalyst.in
2. Facebook Page: / youranalystplus
3. Instagram Handle: / your_analyst_plus
Other Links on the Series
Episode1: Create a Table in SQL | From Excel To SQL
• Creating a table in SQL. Use Excel da...
Episode 2: Sorting Data in SQL | From Excel to SQL
• How to sort data using SQL query |SQL...
These are the SQL queries used in this video . You can use this for your understanding.
Q:1 Find all the data for 'SC Ganguly'
SELECT player, matches, won, lost, winning_percent
FROM captains
where player like 'SC Ganguly'
Q:2 Find all the player who played more than 50 Matches
SELECT player, matches, won, lost, winning_percent
FROM captains
where matches {greater than symbol} 50
Q:3 Find all the players who played more than 50 matches and won more than 50 %
SELECT player, matches, won, lost, winning_percent
FROM captains
where matches {greater than symbol} 50 and winning_percent {greater than symbol} 50
0:00 - Intro
0:20 - Why Learn Where Clause?
0:35 - Agenda
1:40 - Questions to be solved
2:30 - Working on Excel
4:00 - Working on SQL
8:55 - Bonus Section: Count Function
#sql #where #whereclause, #sqlqueries #businessanalysis #dataanalytics #datascienceskills #exceldataanalysis #analytics #sqlinterview #businessanalyst
sql where,where clause,sql interview questions,sql interview questions and answers,where clause in sql,sql server,sql tutorial,data analytics,sql for beginners,sql tutorial for beginners,mysql tutorial,sql where clause
tags: sql tutorial for beginners, sql, sql tutorial, sql for beginners, Excel, MS-EXCEL, SQL, MY SQL, T-SQL, SQL query, SQL tutorial, SQL for beginners, create table in SQL, SQL server, SQL database, datascience, data analytics, business analytics, Excel tips, SQL tips, SQL interview questions, SQL interview preparation, SQL hacks, Excel to SQL
