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.
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