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
- 26855 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / purabi roy(sarkar)
select top 3* from Tablename
where columnname in ( select top 7columnname from table
name order by columnname desc )
and columnname not in( select top 4columnname from
tablename order by columnname desc )
order by columnname desc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the cartesian product of the table?
What is postgresql server?
What is the difference between system objects and user objects?
What are the steps to insert a table?
Sql server reporting services vs. Crystal reports.
What are the components of dbms?
What is the need for indexing?
What is trigger and different types of Triggers?
How to filter out duplications in the returning rows in ms sql server?
Can sql servers linked to other servers like oracle?
What is the difference between stored procedure and user defined functions?
what is blocking? : Sql server database administration
What is recompile sql server?
Tell me in brief how sql server enhances scalability of the database system?
Why do we use stored procedures in sql server?
