how to select 5 to 7 rows from a table, which contains 10 rows?

Answer Posted / tk

select * from Tablename limit 5,7 ;

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are sql functions used?

620


What is function of CUBE ?

608


What do you mean by normalisation?

498


how many clustered indexes can be created on a table? : Sql server database administration

562


What are the different types of join?

566






How can you find out how many rows returned in a cursor?

549


What is Dependency Injection and provide example?

612


How do I uninstall sql server 2014?

520


What are the instances when triggers are appropriate?

523


what is sql server? : Sql server database administration

536


What is default port number for sql server 2000?

593


how you can move data or databases between servers and databases in sql server? : Sql server administration

482


Explain what are the basic functions for master, msdb, model, tempdb databases?

525


What command is used to delete a table from the database in the sql server and how?

540


How to encrypt Strored Procedure in SQL SERVER?

556