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
- 27740 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 table level trigger?
How can we get count of the number of records in a table?
What is use of dbcc commands?
Explain what is use of dbcc commands?
How to assign new column names in a view?
What is difference between inner join and join?
What is the default fill factor value?
What is normalization and denormalization in sql server?
What the class forname () does?
Where sql server usernames and passwords are stored in a sql server?
Write a query for primary key constraint with identity key word?
How can you know if the row fetched from cursor is still valid in underlying table?
How to create a view on an existing table in ms sql server?
Where is my database stored on the hard disk in ms sql server?
Explain the flow of creating a cube? : sql server analysis services, ssas
