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
- 27073 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
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is built-in/administrator?
How to get a list all databases on the sql server?
Explain Capacity planning to create a database? and how to monitor it?
List out the different types of locks available in sql server?
What is sql stored procedure?
What is sql server profiler?
What are logical database components? : SQL Server Architecture
What is rolap and its advantage? : sql server analysis services, ssas
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is t-sql script to take database offline – take database online.
What is resource db in sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
How self join is different from outer join?
Explain the etl (extraction, transformation, and loading)?
