how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21683 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sajida
select rnum, d.* from dept d, (select rownum rnum , deptno
from dept ) e
where d.deptno = e.deptno and rnum between 5 and 7;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you set a trace flag in sql server?
What is a non-clustered index?
Explain the difference between primary keys and foreign keys?
What is the maximum size of sql server database?
When I delete any data from a table, does the sql server reduce the size of that table?
What is the difference between mysql and mysqli?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is the difference between coalesce() & isnull()?
Define compound operators?
What are the hotfixes and patches in sql server?
How to Check if table exists in sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What stored by the master?
Why use “nolock” in sql server?
Explain sql server authentication modes?
