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

Which are the db2 tools to protect integrity of the database?

1170


Why cursor is used in db2?

1090


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

1248


What is null indicator in db2?

1166


What is the difference between nvl and coalesce?

1112


What is explain plan in db2?

1052


What is the result of open cursor statement?

1129


How can you find out the # of rows updated after an update statement?

1158


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

1698


What's The Error Code For Unique Index Voilation?

1309


How many types of page locks can be held in db2?

1094


What are db2 objects?

1093


What is view db2?

1133


What is a db2 collection?

1114


define clustering index.

1072