Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 ?

Answers were Sorted based on User's Feedback



i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

Answer / deepak

Select * from employment table where salary between 1000 to
50000

Is This Answer Correct ?    25 Yes 7 No

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

Answer / yuvaevergreen

select * from employment where salary between 1000 and 5000

Is This Answer Correct ?    17 Yes 1 No

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

Answer / prasanna

select *from emp where salary between 1000 to 50000

Is This Answer Correct ?    9 Yes 7 No

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

Answer / dinesh

option 1:
Select * from empoyment table where salary >=1000 and <=50000

option 2:
select * from employment table where salary between 10000 and 50000

Is This Answer Correct ?    4 Yes 3 No

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

Answer / vaneesh khurana

Hi All

See the ques properly, he wants rows with salary bwtween
1000 to 5000. If one say between, it wont means inculsion
of 1000 and 5000 thus query will be

select * from employee where salary bwtween 1001 and 4999

Is This Answer Correct ?    0 Yes 1 No

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

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

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

Answer / dd

select salary from employment
where sal between 1000 and 5000

Is This Answer Correct ?    1 Yes 3 No

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pl..

Answer / venu

Select * from employment table where salary between 1000 to
50000

Is This Answer Correct ?    4 Yes 8 No

Post New Answer

More DB2 Interview Questions

What is cursor stability in db2?

0 Answers  


How to resolve deadlock issue

5 Answers   IBM,


Which isolation level provides highest data integrity?

0 Answers  


What are delete-connected tables?

1 Answers  


What is a Database Request Module(DBRM)?

4 Answers  


Which command is used to remove all rows from a table?

0 Answers  


What is cobol db2?

0 Answers  


what is parm utility

2 Answers   IBM,


database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  


What is difference between *omit and *nopass?

1 Answers   IBM, TCS,


What is cursor in dbms?

0 Answers  


Give the COBOL definition of a VARCHAR field.

2 Answers  


Categories