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

Answer Posted / venu

Select * from employment table where salary between 1000 to
50000

Is This Answer Correct ?

4 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How can you count the number of rows from a table tab?

1040

What is runstats and reorg in db2?

1237

What is db2 instance?

1016

What type of database is db2?

911

what is the sqlcode -501

12919

What is a trigger in the db2 database?

1014

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

1082

What is meant by union and union all?

948

What is page size in db2?

906

Mention the downsides of page level lock.

1112

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3520

What are concurrency issues?

1029

Which component is responsible for processing sql statements and selecting access paths?

1071

What are the two types of logging in the db2 database? Explain them.

1017

What is syscat in db2?

950