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

What do you mean by data integrity?

1068

What are the different types of sql server replication? : sql server replication

1270

What is the difference between stored procedure and functions?

1133

What are different types of subquery?

1244

How to create view in stored procedure sql server?

1016

What are user-defined functions (udfs) in sql server?

989

What is factless fact table? : sql server analysis services, ssas

1028

What is a cube? : sql server analysis services, ssas

997

Can we use where clause in union?

1065

How to filter records of table in SQL SERVER?

1086

What are policy management terms?

984

How you trouble shoot when any job fails

1937

Does an index slow down updates on indexed columns?

972

What is mapping schema?

1027

Tell me about joins in database system and explain each in detail.

1046