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
25800 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 area unit the various kinds of info compression introduced in sql server 2008?

1088

Explain how to maintain a fill factor in existing indexes?

995

What are the disadvantages of merge replication?

1421

What is service broker?

1005

How to provide default values to stored procedure parameters?

1065

What is the difference between value type and reference type?

919

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1014

How to link tables in sql server?

932

What do you do in data exploration

993

How does a profiler work?

929

Is ssrs support other database except ms sql server?

139

tell me the disaster recovery plan

2516

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1066

How will you know when statistics on a table are obsolete?

1082

State the difference between union and union all?

927