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
- 9639 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
Who developed oracle & when?
How to export data to a csv file?
How to convert raw data type into text in oracle? Explain
What are the uses of linked server and explain it in detail?
Difference between varchar and varchar2 data types?
How to add a new column to an existing table with a default value?
Explain oracle data types with examples?
What is the usage of synonyms?
How to list all user accounts in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to install oracle database 10g xe?
How to start your 10g xe server from command line?
How do I recompile a procedure in oracle?
interview questions with answer for cts
When do I need to use a semicolon vs a slash in oracle sql?
