Saturday 14 September 2013

Where in SQL


Where:-it is used to provide the conditions in the query or it is used to filter the data according to your need
pass your condition after the where clause.

the table on which we perform where clause.

                                                      
Ex:-in this simply we select entire data from table whose id =1.


Ex;-in this we select all the rows whose id >1.


Ex;-in this we select only age column and we want to display the age lies between 30 and 50.




Operators we use in where clause.



we discuss all these operators later.


No comments :

Post a Comment