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
- 26326 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / monty
i have other idea if there is no duplicate record in the
table you can use this
select top 7 *from employee
except
select top 4 *from employee
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is a collation?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain sql delete command?
Can we store videos inside the sql server table?
What is update locks?
What does COMMIT command do?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Explain what are the restrictions while creating batches in sql server?
What is bulkcopy in sql?
What are the advantages of sql azure?
How column data types are determined in a view?
What are the purposes and advantages stored procedure?
What is the query and subquery?
What is change data capture (cdc) feature?
what are triggers? : Sql server database administration
