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


Please Help Members By Posting Answers For Below Questions

List few advantages of stored procedure.

517


How do you clear a log file?

486


How to add an address record into adventureworkslt?

545


what are user defined datatypes and when you should go for them? : Sql server database administration

516


How to add more data to the testing table in ms sql server?

531






How to perform backup for certificates in sql server? : sql server security

573


What is a natural primary key?

499


What is scalar user-defined function?

524


How to create and drop temp table in sql server?

558


What encryption security is available in sql azure?

79


Explain about service Broker functions?

599


Can a rule be bound to any column of any data type?

540


Tell me about joins in database system and explain each in detail.

572


How do I change my passwords (database, LDAP, and so on) without causing an outage?

576


What is exporting and importing utility?

587