OraFAQ Forum: SQL & PL/SQL » To find max sal salary paid to employes in all dept.

Home » SQL & PL/SQL » SQL & PL/SQL » To find max sal salary paid to employes in all dept.

Mon, 02 December 2002 08:21

Suresh
Messages: 189
Registered: December 1998

Senior Member

Hai every one

I would like to find out the highest paid salaries of all department including the employee name and emp number.

suresh

Mon, 02 December 2002 09:05

ann
Messages: 24
Registered: August 2000

Junior Member

Select Max(column name)from table_name. or

select a.empname, b.empnumber, max(salaries) from table1 a, table2 b

Previous Topic:	sql to copy records
Next Topic:	native dynamic sql or DBMS_SQL package

Goto Forum:

]

Current Time: Wed May 15 02:44:41 CDT 2024