Name: Yogesh Mehla Email: Yogesh.mehla@gmail.comYogesh.mehla@gmail.com Website: www.techsapphire.inwww.techsapphire.in Phone: +91-9023262520. - презентация

1 Name: Yogesh Mehla Website: Phone:

2 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

3 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

4 SELECT Statement Sample Table

5

6

7

8 Operators to cover OR AND LIKE IN

9 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 *)

10 Why do we need grouping ? When we need some aggregation

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

12 SELECT FROM WHERE OR AND IN LIKE GROUP BY HAVING

13