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

What is the return type of executeupdate ()?

517


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

593


what's sql server? : Sql server database administration

494


What is TDS(Tabular Data Stream) Gateway?

99


How many types of attribute relationships are there? : sql server analysis services, ssas

580






What is a field in a table?

574


List the different types of collation sensitivities in sql server?

522


What is the use of sign function?

555


What new data source types were added in ssrs 2014?

107


What is a natural primary key?

522


How do I find sql server instance name?

504


Can you import Microsoft Excel data to SSRS?

89


Why de-normalization required?

569


What information is maintained within the msdb database?

537


Explain transaction server isolation?

544