| From: | "shreedhar" <shreedhar(at)lucidindia(dot)net> |
|---|---|
| To: | "Postgre General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Query |
| Date: | 2003-03-29 07:50:54 |
| Message-ID: | 004e01c2f5c7$ecddc890$1201a8c0@a4005 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas T. Thai | 2003-03-29 08:28:14 | NetBSD 1.6 Alpha Postgresql Fix |
| Previous Message | shreedhar | 2003-03-29 07:42:50 | Query Help |