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
- 5163 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is informatica?
Clarify the utilization of aggregator cache record?
how to load dimension table and fact table. plz tell me the steps.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is degenerated dimension?
list out all the transformations which use cache?
What is workflow manager?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the difference between writing a joiner query in ANSI style and THETA style?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is informatica metadata and where is it stored?
explain one complex mapping with logic? sales project?
How to update a particular record in target with out running whole workflow?
How to do unit testing in informatica?
What is a joiner transformation?
