SQL query to get the result
===

Hello friends,

        (1) Table 1                   
    CutomerID    Salary   
    1             2000              
    2             3000              
    3             4000 		
    4             6000		
    5             5220	

       Table 2                          
      DeptID  DeptNam
      1       IT                           
      2       Finance                
      3       Marketing	
    			
 

        Table3
      CustomerID    DeptID
        1            1
        2            1 
        3            2
        4            3
        5            3

Ques - Find the people with highest salary in each dept    
       Rows to return :    CustomerID     DeptName     Salary


Ques - Find the people with highest salary in each dept    
       Rows to return :    CustomerID     DeptName     Salary

Can any body help me out how to write the SQL query for this? 



