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
- 26314 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 to invoke a trigger on demand?
Why use “pivot” in sql server?
Why truncate is ddl?
If a table does not have a unique index, can a cursor be opened on it?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
How to create new table with "create table" statements?
Explain the use of containers in ssis?
What are the dmvs? : sql server database administration
What is the difference between left and right outer join?
Tell me what is difference between clustered and non clustered index?
What is partitioned view?
Can a database be shrunk with users active?
Distinguish between nested subquery and correlated subquery?
What is subquery in sql?
How connect excel to sql server?
