how to select 5 to 7 rows from a table, which contains 10 rows?

Answer Posted / pravnch

Select EmpNo, EName,Sal from EmpTable where EmpNo between 5
and 7

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql server 2000 work load governor?

550


What is the difference between SQL notification and SQL invalidation?

582


What is public role in sql server?

528


Why functions are used in sql server?

499


What are orphan records?

543






Explain few examples of stored procedure over triggers?

509


Does partitioning help performance?

522


What happens to a statement batch if there is a compilation error?

505


Are null values the same as that of zero or a blank space?

567


is there a column to which a default can't be bound? : Sql server database administration

529


What's new in sql management studio for sql server? : sql server management studio

572


What is the difference between for auto and for nested?

499


Explain atomicity?

567


Why is the need for data conversion transformations?

491


What is self contained multi valued query?

548