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

Define data page.

1135

Which component is responsible for db2 startup and shutdown?

1086

What are the bind parameters ibm db2?

1105

Is ibm db2 open source?

1132

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1134

Explain the function done by data manager?

1338

What is release/acquire in bind?

1165

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2268

What is the physical storage length of timestamp data type?

1153

Name the lockable units in DB2?

1189

How do I import data from excel to db2?

1131

How to fetch the last row from the table in SQL (db2)?

1698

What is the picture clause of null indicator variable?

1186

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

1112

What is innodb buffer pool?

1138