How to select nth record from a table?
Answer Posted / karthik
select * from (select rownum r , emp.* from emp)
where
r='&n'
Give the value of n. It will return the nth record.
Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
Tell me in brief how sql server enhances scalability of the database system?
What is cursors?
can a database be shrunk with users active? : Sql server administration
How do I find the port number for sql server?
How to manipulate data from one table to another table ?
What is Replication?
What are the different acid properties?
What is a print index?
What is dimension table? : sql server analysis services, ssas
How to generate create table script on an existing table in ms sql server?
What is difference between view and materialized view?
Explain what is lock escalation?
What is the default order of an order by clause?
What are the authentication modes in sql server? How can it be changed?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?