Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40860 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
Write a SQL query to make a column as unique?
What is @@error in sql?
Explain temporary table vs table variable by using cursor alternative?
Explain system functions or built-in functions? What are different types of system functions?
How to create a dml trigger using create trigger statements?
How to create an inline table-valued function?
How does Report Builder support Analysis Services cubes?
What are the different types of backups that exist?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What’s the use of custom fields in report?
Do you know how to make remote connection in database?
How many clustered indexes there can be on table ?
How network traffic be reduced by using the stored procedure?
Why main is user defined function?
What are cursors in ms sql server?
