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


we have to use order by,where,having we to implement sql query



we have to use order by,where,having we to implement sql query..

Answer / sehaj

IN A QUERY WE CAN USE ALL THE THREE....BUT USING WHERE N
HAVIN DOESN MEAN ANY SENSE...
IF WE USE GROUP BY WE CAN USE WHERE CLAUSE BEFORE GROUP BY
PORT...
AND IF WE USE GROUP BY WE CAN USE HAVING AFTER GROUP BY CLAUSE..
N GENERALLY ORDER BY CLAUSE IS ALWAYS WRITTEN AT THE END OF
THE QUERY

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Informatica Interview Questions

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,


how to return multiple columes through through un-connect lookup?

1 Answers   DELL,


what is the size of your data warehousing?

0 Answers   IBM,


what is size of u r database?

0 Answers  


how will you get 21 to 30 record from 50 records?

6 Answers  


Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,


What are the advantages of using informatica as an etl tool over teradata?

0 Answers  


Major difference between SQL override and Lookup Sql override

1 Answers  


Describe two levels in which update strategy transformation sets?

1 Answers  


How to retrieve last two days updated records?

4 Answers  


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


how can u load the data in time dimension?

3 Answers  


Categories