How to select nth record from a table?
- 13 Answers
- 37876 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
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 ? | 18 Yes | 12 No |
Post New Answer View All Answers
What are user defined functions in ms sql server?
How to integrate the ssrs reports in application?
how can you attach more than 20 ldf files in sql server
Can we call stored procedure in view in sql server?
What is 4nf in normalization form?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How sql server executes a statement with nested subqueries?
What is the return type of executeupdate ()?
What is difference between group by and having?
how would you improve etl (extract, transform, load) throughput?
What are recommended options to be used while using db mirroring? : sql server database administration
What is a non clustered primary key?
Can you explain what is the use of custom fields in report?
how to use DTS package in 2000,2005,2008 in sql server
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
