we have to use order by,where,having we to implement sql query
- 1 Answers
- 4806 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
tell me 5 session failure in real time how can you solve that in your project?
Is it possible to revert a global repository to local one and why?
What is union transformation in informatica?
What is event and what are the tasks related to it?
Explain why we use partitioning the session in informatica?
What is substr in informatica?
What is workflow? What are the components of the workflow manager?
What is difference between a gateway node and worker node?
What are Dimensional table?
what is SDLC way of code development?
scenario where i can use only concurrent execution of workflow.
Explain constraint based loading in informatica
How we can create indexes after completing the load process?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
design of staging area?
