Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

SQL Where

SQL where clause used to specify condition and select statement extract only those records that fulfil a specified condition.

Syntax:

SELECT column_1,column_2..column n
FROM table_name
WHERE some_column operator value;


Example:

SELECT DISTINCT CategoryName,[Description] FROM Categories WHERE CategoryName='books
CategoryName,[Description] FROM Categories WHERE CategoryName='books

Result:



Invalid entry,please enter valid data.

Loading