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
- 5257 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
Is there any way to read the ms excel datas directly into informatica?
What is powercenter on grid?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is sq transformation?
How can we store previous session logs?
what is the difference between informatica6.1 and infomatica7.1
What are the components of workflow manager?
What is the difference between informatics 7x and 8x and what is latest version?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to differentiate between the active and passive transformations?
What is mapping debugger?
What is the difference between a connected look up and unconnected lookup?
Explain joiner transformation in informatica
How do you take back up of repository?
What is the need for an etl tool?
