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
- 5239 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 modules in Power Center
How can repository reports be accessed without sql or other transformations?
What are the different versions of informatica?
What are the different types of repositories created using informatica?
What is enterprise data warehousing?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Target increases every day even though no new record was inserted
Define update strategy?
How does a rank transform differ from aggregator transform functions max and min?
Explain the pipeline partition with real time example?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Where do we use mapping variables in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the procedure for creating independent data marts from informatica 7.1?
Separate from an archive server and a powerhouse?
