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 options are available to audit login activity? : sql server security

639


How to find table changes in sql server?

663


What is sql injection? How to protect against sql injection attack?

557


How many database files are there in sql server 2000?what are they?

583


How to find the login name linked to a given user name?

536






What is 1nf 2nf?

556


What is an etl file?

530


How does Report Builder support Analysis Services cubes?

110


What do you mean by recursive stored procedure?

513


How to fine-tune reports?

153


What are the differences between sql server and mysql.

534


Do you know what are various aggregate functions that are available?

529


what are the different ways to return the rowcount of a table?

579


Do you know what is openxml in sql server?

615


Describe in brief databases and sql server databases architecture.

532