Wednesday, January 2, 2013

Sql IN statement to return all records

Below query will return all records in the table.

select * from tblArea

where AreaDescription in (AreaDescription,'Processing1','Geology 66','Site Infrastructure')

Note the "AreaDescription" column, we have passed it to the IN query so that the query will return all rows in "AreaDescription" column.

No comments:
Write comments
Recommended Posts × +