All Type Coding

Search Here

How to use Where clause in sql server.?

WHERE 
                         clause is used to filter the records/data and apply the conditions in a SELECT,  UPDATE, or DELETE statement from single table or joining with multiple tables.If the given condition is true then only it returns specific value from the table.
Syntax 
                                        Select * from table_name where [condition] 
                                                                    OR
                           Select Column_name1,Column_name2,from 
                  table_name where  column_name operator_name =,like,<,> value 
Now we'll see how to select data from table with where caluse.

















We have the Employee1 table we'll select data from this above table like
                               Select * from Employee1 where id=3
Output will be:












OR












Thus we can filter the data from database table.


No comments :

Post a Comment