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
List few advantages of stored procedure.
How do you clear a log file?
How to add an address record into adventureworkslt?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to add more data to the testing table in ms sql server?
How to perform backup for certificates in sql server? : sql server security
What is a natural primary key?
What is scalar user-defined function?
How to create and drop temp table in sql server?
What encryption security is available in sql azure?
Explain about service Broker functions?
Can a rule be bound to any column of any data type?
Tell me about joins in database system and explain each in detail.
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What is exporting and importing utility?