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
26280 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

Tell me about pre-defined functions of sql?

1158

What are data resources?

963

What is SQL Azure?

107

What are the differences between user defined functions and stored procedures?

1136

Explain “@@rowcount” and “@@error” in sql server?

1132

Differentiate between truncate vs delete in mssql?

1162

how you can move data or databases between servers and databases in sql server? : Sql server administration

1030

What is trace flag in sql server?

1080

How raid can influence database performance?

1087

What are the default system databases in sql server 2000?

1081

what is datawarehouse?

1157

Why do we partition data?

1079

Can coalesce return null?

1070

What is update_statistics command?

1121

How to list all dsn entries on your local machine using odbc_data_source()?

1089