Tuesday, October 11, 2016

SQL where

The where clause use for  specify conditions that filter and find out  desire value .Where clause is use for find out  specific data from the table.


Table name Student
StuId
City
20
France
20
japan
20
France
30
India
10
Bangladesh

Query:

SELECT StuId, City
FROM Student
WHERE StuId = 20


Result:


Count
City
20
France
20
japan
20
France

No comments:

Post a Comment