select top5 * from table minus select top4 from table

how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?

Question Posted / sruthi

16 Answers
26306 Views
Accenture, IBM, Marlabs, I also Faced
E-Mail Answers

Answer Posted / sruthi

select top5 * from table
minus
select top4 from table

Is This Answer Correct ?

5 Yes

19 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what happens on checkpoint? : Sql server database administration

1159

How do indexes help, types?

1014

How can I create a new template for import ? : sql server management studio

1115

Explain system functions or built-in functions? What are different types of system functions?

1045

Explain cdc and sql injection?

1046

What functions can a view be used to performed?

1120

Is it possible for a stored procedure to call itself or recursive stored procedure?

1008

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1197

Tell me can we use custom code in ssrs?

1060

what are database files and filegroups? : Sql server database administration

1001

Explain powershell included in sql server 2008?

1120

How to use linked server?

1275

What does the not null constraint do?

1182

What is the difference between for auto and for nested?

1070

How to use "begin ... End" statement structures in ms sql server?

1121