How to select the max salary per department

How to select the max salary per department

References

Reference NO 1

http://stackoverflow.com/questions/15189328/how-to-select-the-max-salary-per-department-including-the-employees-that-earn-i

Reference NO 2

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29058

Reference NO 3

http://www.dbforums.com/ansi-sql/1670851-count-max-salary-each-department.html

Reference NO 4

http://forums.anandtech.com/showthread.php?t=2157995

Reference NO 5

http://www.oracle.com/technetwork/issue-archive/2005/05-mar/o25dba-091480.html

Reference NO 6

http://beyondrelational.com/modules/3/ask/0/questions/15997/how-can-i-find-department-wise-highest-salary.aspx

Reference NO 7

http://www.dotnetfunda.com/forums/thread1684-how-to-query-for-second-highest-salary-in-emp-in-each-department.aspx

Reference NO 8

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3d362d7c-18c2-4350-b109-de88131edd95/action?threadDisplayName=select-max-group-by