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
26263 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 we can compare two database data?

997

What are the security related catalog views? : sql server security

992

What is the default port for SQL Server over a firewall?

1143

How to access the deleted record of an event?

1091

What is ms sql server index?

1149

What are the difficulties faced in cube development? : sql server analysis services, ssas

1099

Do you know what is openxml in sql server?

1113

What is the concept of optimization?

1110

Explain tablesample?

1038

How you would rewrite the sql query to return the customerid sorted numerically?

1046

How to loop through result set objects using odbc_fetch_row()?

1044

Explain the dirty pages?

1050

What are the disadvantages of using the stored procedures?

1186

whats new about truncate in sql server 2008?

2553

Can we do dml on views?

1015