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
- 5337 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 are the different types of repositories created using informatica?
In development project what is the process to follow for an etl developer from day1
Design time, run time. If you don't create parameter what will happen
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
expain about the tune parameters?
Differences between connected and unconnected lookup?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Parameter and variable differences
In which transformation you cannot drag ports into it?
In informatica workflow manager, how many repositories can be created?
What are mapplets? How is it different from a Reusable Transformation?
what is the difference between informatica6.1 and infomatica7.1
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are roles and groups and benefits of using them?
What is exclusive and normal mode for repository services?
