select * from employment where salary between 1000 and 5000

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 / yuvaevergreen

Answer Posted / yuvaevergreen

Is This Answer Correct ?

17 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can you do the explain of a dynamic sql statement?

1112

How is the value function used?

1214

Is db2 a mainframe database?

1053

What is lock escalation in db2?

1085

Define declaration generator (dclgen).

1172

What is a db2 cursor?

1112

What is universal database?

1122

How to execute stored procedure in db2 command editor?

1105

Explain about rct in db2?

1166

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2914

Mention data types used in db2 ?

1205

What is innodb buffer pool?

1138

What is image copy in db2?

1077

Mention some fields that are a part of sqlca.

1101

Explain the contents that are a part of dclgen.

1141