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
- 5345 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
Differentiate between sessions and batches?
Differentiate between router and filter transformation?
What do mean by local and global repository?
Informatica settings are available in which file?
What is an unconnected transformation?
Why do we need informatica?
What is DR strategy for Informatica project?
which one is better performance wise joiner or look up
What is an expression transformation?
What are the different versions of informatica?
What are the different ways to implement parallel processing in informatica?
Differentiate between source qualifier and filter transformation?
What is an expression transformation in informatica?
Under which circumstances, informatica server creates reject files?
How to create or import flat file definition in to the warehouse designer?
