how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21802 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 is delete query?
Name and describe few console utilities for ssrs?
What is sql server schema compare? How we can compare two database schemas?
Which table keeps the locking information?
How to backup encryption key ?
What is the difference between stored procedure and user defined functions?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is standby servers? Explain types of standby servers.
Why we should not use triggers?
What are key constraints?
what are the new features in SSRS?
What are the two modes of authentication in sql server?
How to encrypt Strored Procedure in SQL SERVER?
Tell me when is the update_statistics command used?
What is encryption key?
