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

How to use copy and concatenate commands in SQL?

1119

What do you mean by data manipulation language?

993

What are basics of policy management?

1084

What is @@rowcount in sql?

984

What are the advantages dts has over bcp?

979

What is a non equi join?

954

How do I setup a sql server database?

1053

If the job running very slow what is the action you do

1876

What are extended events in sql server?

937

Do you know query execution plan?

1147

How many triggers are possible per table?

1073

What is dimension table? : sql server analysis services, ssas

1001

What stored by the model?

1033

What is sql view?

999

How to create a simple stored procedure in ms sql server?

1014