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
25246 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 is logon trigger?

1030

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

909

explain different levels of normalization? : Sql server database administration

932

What do you mean by an execution plan? Why is it used?

954

Explain what is lock escalation and what is its purpose?

875

How to sort query output in descending order in ms sql server?

902

Where are full-text indexes stored?

948

Mention what are the different types of ssrs reports?

144

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

962

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

965

SQL Server Architecture ?

2399

Can two tables share a primary key?

952

What are “unrepeatable reads”?

1176

how can a database be repaired? : Sql server administration

925

What is 5nf in normalization form?

937