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 the difference between drop table and delete table?

1291

What is db2 instance?

1165

How to execute stored procedures?

1178

What is role in db2?

1165

What are the bind parameters ibm db2?

1105

What is the difference between cursor and select statement?

1154

What is db2 connect?

1126

What is a bind card?

1281

What is cursor in dbms?

1119

If I have a view which is a join of two or more tables, can this view be updateable?

1188

What is bufferpool in db2?

1099

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1112

What is schema in db2?

1084

What is cursor with hold option in db2?

1138

What is the physical storage length of date data type?

1311