write a query to get maximum salary from the employers table
without duplicates....kindly help me
Answer Posted / deva
select (distinct max(sal)) from emp
group by sal.
When ever you use goupfunctions in select statement grup by clause is must.....other wise it will throw an error
| Is This Answer Correct ? | 8 Yes | 13 No |
Post New Answer View All Answers
what is Active lock explain
What are the static cache and dynamic cache in informatica?
How does a sorter cache works?
Explain sessions. Explain how batches are used to combine executions?
What do you mean by filter transformation?
How can you validate all mappings in the repository simultaneously?
Explain the scenario which compels informatica server to reject files?
What is session task and command task?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the difference between a repository server and a powerhouse?
What is the procedure for creating independent data marts from informatica 7.1?
What are the different types of olap? Give an example?
In development project what is the process to follow for an etl developer from day1
Which files are created during the session rums by informatics server?
what is INFORMATICA TESTING process