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)?

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

In which sql server version report builder introduced?

105


Where can you add custom error messages to sql server?

580


What are magic tables in sql server?

623


when you create a database how is it stored? : Sql server database administration

491


What is inner join? Explain with an example?

688






What is the Control Flow in SSIS

573


What are the advantages of using stored procedures in sql server?

508


How sql server enhances scalability of the database system?

589


What is sqlcmd?

555


Do you know data definition language, data control language and data manipulation language?

624


What number sorts of privileges are accessible in sql?

597


How to optimize stored procedure optimization?

517


What is an example of a foreign key?

507


How adventureworkslt tables are related?

531


How do I completely remove sql server instance?

566