Hi,

If u want first client name details then use rowcount option.

Rowcount keyword is inform to the sql server fetch the mensioned records from table.

Ex:

set rowcount 1

select

LastName,

FirstName,

SalesRep,

Quarter

from MyClientTable

order by LastName,FirstName,SalesRep,Quarter

set rowcount 0

Thanks & Regards,

G.Sethuraj (Sivakasi, TamilNadu,India)