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

8 Answers
14165 Views
Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
E-Mail Answers

Answer Posted / deepak

Select * from employment table where salary between 1000 to
50000

Is This Answer Correct ?

25 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a db2 package?

1068

What is the use of with ur in db2?

1058

How to find the number of rows in db2 tables?

1073

Explain what are the various isolation levels possible?

1047

What is a db2 cursor?

1064

What are the rules for db2 programming?

1099

How to execute stored procedure in db2 command editor?

1053

What is nvl in db2?

1103

What are the different types of base tables?

1100

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2073

What is bind in db2?

1055

How do I connect my db2 database to ibm?

1054

How to execute stored procedures?

1135

What is the difference between cursor and select statement?

1114

what are bind concepts in db2 cobol?

1098