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
- 27203 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kaviraj.y
SELECT * from emp_table WHERE e_id>=5 AND e_id<=7;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List out the differences between the clustered index and non-clustered index in sql server?
What is the size of transaction log file?
How we create SQL Server 2005 Reporting Services ? Give me Sample
After removing a table from database, what other related objects have to be dropped explicitly?
What are basics of policy management?
What are pessimistic lock and optimistic lock?
can you instantiate a com object by using t-sql? : Sql server database administration
What do you mean by recursive stored procedure?
What do you understand by a stored procedure?
How many replicas are maintained for each sql azure db?
Differentiate between ms sql server reporting services vs crystal reports?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
How to handle error or exception in sql?
What is logshipping and its purpose?
What are the different authentication modes in sql server?
