Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 41324 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
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
When would you use a before or after trigger?
What are orphan records?
What causes index fragmentation?
What are the steps you will take to improve the performance of a poor performing query?
Relational calculus is what type of language?
What are diverse clauses that form a part of sql?
What is a with(nolock)?
What is the difference between mysql and mysqli?
How to concatenate two binary strings together?
What are the properties and different types of sub-queries?
Explain Reporting Life Cycle?
How to enter date and time literals in ms sql server?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How would we use distinct statement? What is its use?
What is the use of keyword with encryption. Create a store procedure with encryption?
