Top Query in sql server 2005 | with example

How to use top query in sql server 2005.
select only one record from client table using top query.
Query to display single record using top query.



select * from clnt_tb

1    ram    singh    898979999    10000
2    rama    hihi    8869    8889
3    ramayan    rahi    443434343    12345

SELECT TOP (1) cl_id, cl_name, cl_lst_name, cl_phone, cl_sal
FROM clnt_tb

second way
SELECT TOP (1) *
FROM clnt_tb

1 ram singh 898979999 10000

Share This