Click here to Skip to main content
15,892,809 members

Comments by sazzad37 (Top 48 by date)

sazzad37 14-Jan-17 21:58pm View    
Ok, Thanks
sazzad37 14-Jan-17 5:40am View    
Can you please share me the right one.
sazzad37 14-Jan-17 5:29am View    
This is not homework, Actually I am learning SQL to prepare myself for job interview. I found this problem somewhere and try to solve it. Is the following modified query works right? Thank's for your valuable response.

SELECT Company_name, SUM(e.Salary) AS Highest_Salary FROM employee AS e, salary AS s, company AS c WHERE e.city = s.city AND e.city = c.city GROUP BY Company_name ORDER BY Highest_Salary DESC LIMIT 1
sazzad37 6-Dec-15 12:33pm View    
Thank you very much. This is what I searching for.
sazzad37 13-Mar-15 11:07am View    
Thank you very much.