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...

following scenario empsal table i want who exist one lakshs
sal above monthwise?
`
empsal

empid monthyear sal
1 jan2008 1000
2 march2009 50000
3 april2009 4000
4 feb2009 100000
5 jul2009 600000
6 dec 2008 90000

Answer Posted / animesh

Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are factless facts? And in which scenario will you use such kinds of fact tables.

1789


Explain your project of banking domian.

1639


Differentiate between source qualifier and filter transformation?

1561


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2163


What do you understand by SOA of Informatica?

961


Plz can any one say me how to get the informatica certification materials and dumps

2030


What is the need of an ETL tool?

1069


How you prepared reports for OLAP?

1584


if we have a delimiters at unwanted places in a flat file how can we over come those.

2023


What are the different types of olap? Give an example?

1030


Which files are created during the session rums by informatics server?

1150


How will the document be delivered to me?

1060


r u done any partitions in ur project?

1805


What is sorter transformation?

1021


How to load the data from a flat file into the target where the source flat file name changes daily?

1037