Interested to Buy Any Domain ? << Click Here >> for more details...
how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 26893 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
Explain syntax for viewing, dropping and disabling triggers?
What are a database and a data warehouse?
Explain index in sql server?
What do you mean by an execution plan? Why is it used?
What are the properties and different types of sub-queries?
How to populate a table in sql server?
What do you mean by an execution plan?
What is the difference between sdf and mdf?
What is collation sensitivity?
Tell me what is difference between view and materialized view?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is the difference between Triggers and Stored Procedure?
How to recompile stored procedure at run time?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Name three of the features managed by the surface area configuration tool? : sql server security
