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 the difference between ‘having’ clause and a ‘where’ clause?
What is key set driven?
What is row-level compre?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What are “lost updates”?
What is SQL Azure?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Why use cursor in sql server?
How to enforce security in sql server? : sql server security
What is scan table/view and seek table/view when its occurs? : sql server database administration
What are alternate keys?
What is schemabinding a view?
What is parameterized reports in ssrs ?
Can sql servers linked to other servers like oracle?