Interested to Buy Any Domain ? << Click Here >> for more details...
we have to use order by,where,having we to implement sql query
- 1 Answers
- 5254 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
What are the restrictions of union transformation?
What is the Rankindex in Ranktransformation?
How do you change a non-reusable transformation to reusable transformation?
What are connected or unconnected transformations?
How to create Target definition for flat files?
when informatica 8 series released ?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Why we require dwh in particular projects?
Explian the Process of deployment groups in informatica
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
What is the difference between Bitmap and Btree index?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
Teradata 
