how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / priyanka
select top 3 * from emp where id not in
(select top 4 id from emp order by id)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you explain powershell included in sql server 2008?
How do you trace the traffic hitting a sql server?
how can you check the level of fragmentation on a table? : Sql server administration
How do I start and stop sql server?
How to call a function from a stored procedure in SQL Server ?
What is instead of trigger sql server?
What is data modification?
What is the purpose of linked server configuration in sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are different types of statements that are supported by sql?
What is the recursive stored procedure in sql server?
How to Sync Two SQL Azure Databases?
What is the difference between web edition and business edition?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is 1nf normalization form?