Interested to Buy Any Domain ? << Click Here >> for more details...
I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
- 5 Answers
- 9802 Views
- Microsoft, Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / vengalrao
Dear Friends,
Depends upon table u can pick one max value is possible,one
table u cannot pick max value of all columans , then u can
refer one any ne column
select depid,max(sal) from <table name> group by depid;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the restrictions on external table columns?
What is dynamic proxy?
What are the roles of dba?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is primefaces used for?
What is oracle instant client?
How to convert a string to a date in oracle database?
What is raw datatype?
What happens to the indexes if a table is recovered?
What is the minimum client footprint required to connect c# to an oracle database?
What is the quickest way to fetch the data from a table?
What's dateware house and what's clustor with practicle example
How to change user password in oracle?
How to select all columns of all rows from a table in oracle?
What is oracle sid?
