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

Does order by actually change the order of the data in the tables or does it just change the output?

1078

How to provide login information for a new odbc dsn?

978

Explain what is the purpose of sql profiler in sql server?

1007

Give main differences between "Truncate" and "Delete".

1029

what are the different stages of Report Processing?

125

How to stop a loop early with break statements in ms sql server?

972

What is the difference between local and global temporary tables?

1074

Explain query editor regions

1002

Is truncate a dml command?

887

Can we take the full database backup in log shipping?

898

what are the types of indexes? : Sql server database administration

1057

What is a unique key constraint?

968

What is normalization and its types?

960

How is a full-text index updated?

895

What are the triggers in sql?

1017