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

Explain index in sql server?

1068

What is TDS(Tabular Data Stream) Gateway?

127

How do clustered indexes store data?

1157

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1118

where the connection string store in the database

2124

Do you know what is openxml in sql server?

1119

How will you find out if there are expensive SQL statements running or not?

1076

How do I view views in sql server?

1065

Explain the advantages of merge replication?

1013

What is the Control Flow in SSIS

1153

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1102

Define Joins?

1078

Explain log shipping?

1078

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1034

What is global temp table?

1047