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
- 27071 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
How many clustered indexes there can be on table ?
Characterize join and name diverse sorts of joins?
How many primary keys are possible in a table?
Is there any difference between the primary key and unique key?
Will count(column) include columns with null values in its count?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How do I find query history in sql server?
When you should use a low fill factor?
What is the ‘fillfactor’?
Tell me what is difference between clustered and non clustered index?
What is attribute? : sql server analysis services, ssas
What is a heap?
How to modify an existing stored procedure in ms sql server?
List some case manipulation functions in sql?
How to start sql server browser service?
