fetch the 5th record from a table of 10 records: select * from emp limit 4

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 / sneha s

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

Answer Posted / sneha s

fetch the 5th record from a table of 10 records:
select * from emp limit 4,1;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the advantages of user defined function?

1046

What is efficiency data?

1004

Which tcl commands are available on the sql server?

1143

Difference between drill down and drill through report.

1009

What are the advantages of stored procedure in sql server?

936

How do I get to sql server configuration manager?

1067

What is optimization and its types?

1043

Explain intellisense for query editing

1076

How do you know if sql server is running on your local system?

1106

What have included columns when we talk about sql server indexing?

1082

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

176

Can sub report data source be different from that of the parent report?

149

What is the dbcc command and why is it used?

1111

How can we solve concurrency problems?

1099

What is blocking and how would you troubleshoot it? : sql server database administration

1101