set rowcount 5 select * 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 / ashim pal

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

Answer Posted / ashim pal

set rowcount 5

select * from table_name

Is This Answer Correct ?

7 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to filter records of table in SQL SERVER?

1086

Explain alternate key, candidate key and composite key in sql server?

915

Why we should not use triggers?

963

application server is slow what may be the problem

2223

Please differentiate between a local and a global temporary table?

1007

What are the advantages of sql stored procedure?

1074

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1005

Write a program using SQL queries to find a unique entry in a table.

994

What is a livelock?

966

What is federation member?

116

Describe triggers features and limitations?

989

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1163

How to create a ddl trigger using "create trigger" statements?

1132

Explain the working of sql privileges?

1092

How you can get the list of largest tables in a database?

1015