we have to use order by,where,having we to implement sql query
- 1 Answers
- 4622 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
What is the query to find nth highest salary? What is the use of cursors?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
How many joins in Informatica
what is mean by grouping of condition column in lookup transformation?
What is the difference between view and materialised view?
What is dimensional table?
I have source like this 1:2;3. so i want to load the target as 123
How do you change parameter when you move it from development to production.
how to convert the .doc docs into .txt format using informatica
tell me the rules and responsblites in our project(my project is development)
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
without table how to come first record only in oracle?
Teradata 
