how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21552 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tb
select a.empid, a.ename,a.salary from (select * from emp
order by empid desc LIMIT 6) b INNER JOIN (select * from
emp order by empid asc LIMIT 7) a on b.empid=a.empid
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What it means to be triggered?
What is difference between count (*) and count 1?
What is 2nf normalization form?
What are differences in between sql server 2012 and sql server 2016?
What do you mean by tablesample?
Do you know what are the ways available in sql server to execute sql statements?
When a primary key constraint is included in a table, what other constraints does this imply?
Can we delete data from a view?
Define inner join? Explain with an example?
What is the Difference Between Primary and Foreign Key?
What is difference between inner join and join?
What does the on update no action do?
what is hash nonclustered index
How to create new table with "create table" statements?
what are the disadvantages of cursors? : Sql server database administration
