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
Write a sql query to get zero records from a table having n number of records?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Explain what is public role in sql server?
Explain subquery and state its properties?
Can multiple columns be used in sql group by clause in ms sql server?
What is the maximum row of a size?
What is store procedure? When do you use?
Why use stored procedures in sql server?
What is the contrast between sql and mysql?
Define right outer join in sql server joins?
What is the difference between getdate and sysdatetime?
What is trigger in salesforce?
How to retrieve error messages using odbc_errormsg()?
What is a cache in ssrs?