How to select nth record from a table?
Answer Posted / sajida
--For ex in dept table to select 5th record. Instead of
this you can use &n so that it can ask row number
select rnum, d.* from dept d, (select rownum rnum ,
deptno from dept ) e
where d.deptno = e.deptno and rnum = 5
Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
Can a database be shrunk with users active?
Give a example to search fr a string in all stored procedure in sql server.
How to scale out a federation by Sql statement?
What options are available to audit login activity? : sql server security
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is a field in a table?
What are the different subsets of sql?
What do you mean by collation recursive stored procedure?
What is pivot and unpivot?
What is sql or structured query language?
what information is maintained within the msdb database? : Sql server administration
How to replace given values with null using nullif()?
What is Service Broker in sql server 2012?
Is candidate a key?
List out the different types of locks available in sql server?