Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Top records

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-21 : 12:09:57
Arzan Rateshtari writes "How do i retreive only the top 5th record out of the top 5 records using TQL?

For Example:

Top 5
-----
1 ABC
2 CDE
3 EFG
4 HIJ
5 KLM


Required Output
---------------
5 KLM


Is there any direct function like the one in oracle rowno.

regards
Arzan"
   

- Advertisement -