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
Tell me the phases a transaction has to undergo?
What is default constraint in ms sql server?
What are the character string functions supported by sql server 2005?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
How to change the data type of an existing column with "alter table" statements in ms sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
Can we join two tables without primary key?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What do you mean by an execution plan? Why is it used? How would you view it?
What is sql server management studio? : sql server management studio
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
How to enter unicode character string literals in ms sql server?
How to use values from other tables in update statements in ms sql server?
What are the properties of primary key?
What is transaction server distributed transaction?