It is concept through which those many records are displayed where a condition is satisfied. It is also called Row restriction.
The Where clause is used in most cases to restrict the number of rows. Where clause typically increases query performance by limiting the amount of data to be sent back to the client application.
Syntax :
Select <exp> from <T_Name> [where <condition>];
NOTE:
SQL statement are case insensitive.
The Where clause is used in most cases to restrict the number of rows. Where clause typically increases query performance by limiting the amount of data to be sent back to the client application.
Syntax :
Select <exp> from <T_Name> [where <condition>];
NOTE:
SQL statement are case insensitive.
