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

Question Posted / anu63.p

1 Answers
5272 Views
Satyam, I also Faced
E-Mail Answers

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

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

What is union transformation in informatica?

0 Answers

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers Cognizant, Wipro,

What are the types of metadata that stores in repository?

2 Answers

What are the main issues while working with flat files as source and as targets ?

0 Answers Informatica,

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers CTS,

My source table having some records ,i want load 1st record and last record into one target?

3 Answers iGate,

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers TCS,

What is aggregate cache in aggregator transforamtion?

5 Answers

When the informatica server marks that a batch is failed?

2 Answers

what is the function of 'F10' informatica ?

4 Answers IBM,

How would you join a node to the already existing domain?

0 Answers

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers CTS, TCS,

For more Informatica Interview Questions Click Here