how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21801 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
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Explain what are commit and rollback in sql?
Difference between report and query parameter. Why do we need different type of parameter?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What are the events recorded in a transaction log?
Define model database?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is a mutating table error and how can you get around it?
What is the purpose of object explorer and its features? : sql server management studio
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is Replication?
Write a code to select distinct records without using the DISTINCT keyword.
How is sql server used?
