Select * from employment table where salary between 1000 to 50000

i have an employment table whch has salary,dept,name? i want
salary b/w 1000 to 5000 can anyone pls say the query for ths ?

Question Posted / deepak

Answer Posted / deepak

Select * from employment table where salary between 1000 to
50000

Is This Answer Correct ?

25 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is db2 connect?

601

What is the maximum number of columns in a db2 table?

721

Why do we need reorg in db2?

558

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

639

What is the cobol picture clause of the db2 data types date, time, timestamp?

611

What is null indicator in cobol db2?

580

What are the various isolation levels possible?

645

How to check sequence on a table in db2?

598

Explain packages.

655

What is a dbrm in db2?

574

What is reorg and runstats in db2?

690

What is copy pending and check pending in db2?

570

What are foreign keys in db2?

614

How do you select a row using indexes in db2?

643

How do I delete a table in database?

595