Interested to Buy Any Domain ? << Click Here >> for more details...
how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 26862 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tk
select * from Tablename limit 5,7 ;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between delete,drop and truncate in SQL Server?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can you explain the disadvantages/limitation of the cursor?
What is use of except clause?
What is the purpose of the tempdb database?
What are pessimistic lock and optimistic lock?
Can we write a distributed query and get some data which is located on other server and oracle database?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
How do you create type- insensitive operator?
What are the different types of Indexes available in SQL Server?
How can you know if the row fetched from cursor is still valid in underlying table?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
why would you use sql agent? : Sql server database administration
Can the query output be sorted by multiple columns in ms sql server?
Explain the flow of creating a cube? : sql server analysis services, ssas
