i have other idea if there is no duplicate record in the table you can us

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / monty

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

Please Help Members By Posting Answers For Below Questions

What is outer join in sql server joins?

1126

How to delete all rows with truncate table statement in ms sql server?

1005

What are the disadvantages of using querystrings to send data from one page to another?

1008

How to return the second 5 rows in ms sql server?

1068

Why it is recommended to avoid referencing a floating point column in the where clause?

971

How to create a stored procedure with a statement block in ms sql server?

1072

How to list all columns in a table using odbc_columns()?

976

Explain powershell included in sql server 2008?

1065

How to list all stored procedures in the current database using ms sql server?

1139

Explain how you can configure a running aggregate in SSRS?

163

What is the Control Flow in SSIS

1098

How to rebuild master databse?

1086

What are wait types?

1125

What is the order by used for?

1024

What is the significance of null value and why should we avoid permitting null values?

992