how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / ajay
select * from emp where sno between 5 and 7
ajay.thomala@gmail.com
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is a group function explain with an example?
Why do you want to join software field as you have done your BE in Electronics?
How can a user-defined datatype be created?
What are the restrictions while creating batches in sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
What are triggers? How do you invoke a trigger on demand?
Where are SQL server users names and passwords are stored in sql server?
Tell me what is difference between view and materialized view?
Find nth lowest salary or get nth lowest salary?
What is the difference between ‘having’ clause and a ‘where’ clause?
What purpose does the model database server?
What is CTE in SQL
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain Geometry datatype in sql server 2008 with example
How to return the date part only from a sql server datetime datatype?