Name: Yogesh Mehla Website: Phone:

Simple SQL Queries Working with WHERE Clause GROUP BY Clause HAVING Clause Next Lecture Why we need relational tables ? How JOIN works ? And lot of Practical

It is high level language which provide you capability to query data from any structured data source (Tables). High level language means language which is used by us to communicate (English). For learning, we will be using online SQL editor provided by W3C. ename=trysql_select_all

SELECT Statement Sample Table

Operators to cover OR AND LIKE IN

Parenthesis are having highest precedence (Will be considered before all conditions) WHY ? Simple Maths * 5 =12 (* has high precedence then +) (2+2)*5=20 (Parenthesis has high precedence then *)

Why do we need grouping ? When we need some aggregation

Which product got sold ? (Detail) How many times product got sold ? (Aggregation) Customers with address ? (Detail) How many customers ? (Aggregation)

SELECT FROM WHERE OR AND IN LIKE GROUP BY HAVING