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

Answer Posted / govind

select * from emp where empid between 5 and 7

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of sql server replication? : sql server replication

622


Can a database be shrunk to 0 bytes, if not, why?

642


What are extended events in sql server?

506


Tell me what is de-normalization and what are some of the examples of it?

567


What is 3nf normalization?

560






Explain Reporting Life Cycle?

90


Tell me what is fill factor?

555


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

606


What is user-defined multi-statement table-valued function?

655


What are the new scripting capabilities of ssms? : sql server management studio

552


What is normalization of database?

599


What are magic tables in sql server?

623


between cast and convert which function would you prefer and why?

532


What is a unique index?

527


What is store procedure? How do they work?

577