how do you restrict resultset to return only one row? 2

[password99]

how do you restrict select resultset to return only one row?

 

[donutman]

Select Top 1 * from WhatEver where SomeCondition etc.
-Karl

 

[TysonLPrice]

I'm not quite sure this is what ou mean but:

"select top 1 * from table_name" will get you one row. You can add the usual where and order by stuff to pare it down.

 

[nikhilparchure]

Another way

Set RowCount 1

--- Your Select Query

Set RowCount 0