revathy

• Jan 23rd, 2007

 

we can run a query like below :select first 1 * from <table name> It worked in informix..please check in other databases..

rohini

• Jan 31st, 2007

 

select * from <table name> limit 1;

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

 

SELECT * FROM EMPLOYEES WHERE ROWNUM=1;

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

 

SELECT * FROM EMPLOYEES WHERE ROWNUM=1; IN ORACLE

kmuddana

 Profile Answers by kmuddana 

• Apr 30th, 2008

 

Select top1 * from<Table name> in SQL Server