Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to get maximum salary from the employers table
without duplicates....kindly help me
- 5 Answers
- 10238 Views
- CTS, I also Faced
- E-Mail Answers
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 native users?
Can we override a native sql query within informatica?
What is flashback table ? Advance thanks
how tokens will generate?
What is informatica etl tool?
Different circumstance which drives informatica server to expel records?
What is domain and gateway node?
How does a sorter cache works?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is expression transformation?
What are the mapping parameters and mapping variables?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is a mapplet/worklet in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
What does reusable transformation mean?
