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 ?

Answer Posted / dd

select salary from employment
where sal between 1000 and 5000

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

On which levels locks can be applied?

1065


Which isolation level provides highest data integrity?

1047


What is the difference between db2 and oracle?

1070


What is dbrm? What it contains?

1112


How does db2 sample database connect?

975


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1009


Discuss about db2 bind?

1054


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1137


Explain various types of locks in db2?

1087


What is the physical storage length of date data type?

1192


What is sqlca?

1002


What is a db2 tablespace?

1003


How to check last update on table in db2?

1009


What is the use of value function?

1076


Define check constraint.

1029