we have to use order by,where,having we to implement sql query
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 |
Design a mapping to load the cumulative sum of salaries of employees into target table?
how to return multiple columes through through un-connect lookup?
what is the size of your data warehousing?
what is size of u r database?
how will you get 21 to 30 record from 50 records?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What are the advantages of using informatica as an etl tool over teradata?
Major difference between SQL override and Lookup Sql override
Describe two levels in which update strategy transformation sets?
How to retrieve last two days updated records?
What is the way to execute pl/sql script using informatica mapping?
how can u load the data in time dimension?