Select * from employment table where salary >= 1000 and >= 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 / rabindra mishra

Answer Posted / rabindra mishra

Select * from employment table where salary >= 1000 and
>= 50000

It will work Faster then all the above queries

Is This Answer Correct ?

5 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is the difference between plan and package in db2?

1039

What is the use of with ur in db2?

1004

What is dbrm library?

1004

How to retrieve rows from a db2 table in embedded sql?

1329

How do I add a column to an existing table in db2?

979

Explain about rct in db2?

1047

Explain the function done by data manager?

1220

what are bind concepts in db2 cobol?

1036

What is a db2 collection?

982

What is alias in db2?

984

Explain db2.

993

What is explain in db2?

962

Explain package in db2 and its advantages?

1139

What do you mean by between and in? Is between inclusive of specified range values?

1041

How can the duplicate values be eliminated from db2 select?

1044