How to select nth record from a table?
Answer Posted / saravanan p
Select top 1 * from
(Select top n * from tbl order by column name asc)tbl1
order by column name desc
| Is This Answer Correct ? | 19 Yes | 12 No |
Post New Answer View All Answers
What number aggregate functions are accessible there in sql?
What are different types of table joins?
What is log cache in sql server?
How ssrs maintain security?
What's the information that can be stored inside a bit column?
What does select 1 mean?
What is bookmark link in ssrs?
List down some advantages of sql stored procedure?
What is the use of “join” in sql server?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to configure odbc dsn with different port numbers?
How dts is used to extract, transform and consolidate data?
Explain features and concepts of analysis services?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How will you hide an attribute? : sql server analysis services, ssas