select * from <table name> order by <column name> limit 0,5;

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 / vamsi krishna

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

Answer Posted / vamsi krishna

select * from <table name> order by <column name> limit 0,5;
or
select * from <table name> limit 0,5;

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how many bits ip address consist of? : Sql server database administration

881

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2728

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

945

How to replace null values in expressions using isnull()?

1081

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1121

How to fetch the next row from a cursor with a "fetch" statement?

1056

what are the different types of SSRS reports?

151

How to drop an existing table?

988

What happens if null values are involved in arithmetic operations?

990

Where cross join is used?

937

What is sql server replication? : sql server replication

965

What are the acid properties?

988

Will sql server 2005 allow you to reduce the size of a column?

967

What is a collation?

1074

Introduction of rollup clause using sum and group by clause?

938