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
- 27761 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 are different types of data sources?
What is query processing?
How do you start single user mode in clustered installations?
What are the dmvs?
What is the difference between a unique key and primary key?
Explain how many types of relationship?
What are the restrictions that views have to follow?
explain the storage models of olap? : Sql server database administration
Write the syntax for stuff function in an sql server?
Explain indexing and what are the advantages of it?
How to transfer data from a cursor to variables with a "fetch" statement?
How to write a query with a right outer join in ms sql server?
How many types of the database links?
What is statement level trigger?
What is set nocount on?
