Query - Mailing list pgsql-general

From shreedhar
Subject Query
Date
Msg-id 004e01c2f5c7$ecddc890$1201a8c0@a4005
Whole thread Raw
List pgsql-general
Hi All,
 
table consists of following data
 
empname     deptid         salary
 
xx                 1            10000
xx1               2            5000
xx2               1            20000
xx3               1            10000
xx4               3           50000
xx5               4            10000
 
Can any body give Query to retreive employ name from department with maximum employee who is getting maximum salary.
 
expected result :
 
empname: xx2   
 
Thanks And Regards,
Sreedhar

pgsql-general by date:

Previous
From: "shreedhar"
Date:
Subject: Query Help
Next
From: "Thomas T. Thai"
Date:
Subject: NetBSD 1.6 Alpha Postgresql Fix