how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 21705 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 the report builder?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How do I view a script in sql server?
Are null values the same as that of zero or a blank space?
What are the advantages dts has over bcp?
What are the pre-defined functions in the sql server?
What is default port number for sql server 2000?
1 01 101 01010
What is difference between stored procedure and user defined function?
Do you know what are acid properties?
What the different topologies in which replication can be configured?
How to create stored procedures with parameters in ms sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
What is use of except clause? How it differs from not in clause?
What is the difference between varchar and nvarchar?
