Great :)

well done

what does the group by 1 do?

Why you limited selection just with 1 person? What will be the answer if two or three people will have the same equal total salary and it will be equal?

This solution works 2 times slowly than subquery

WHERE salary * months = (select max(salary * months) FROM `Employee`)

For more literal code:

select salary*months as earnings, count(*) from employee
group by earnings
order by earnings desc limit 1;

For more lazy:

select salary*months as earnings, count(*) from employee
group by 1
order by 1 desc limit 1

To use WHERE:

select salary*months, count(*) from employee
where salary*months = (select max(salary*months) from employee)

I am getting wrong answer for this.

This wont work in 'Oracle' because group by is executed before select in SQL . Am I right?

Amazing :)

this is not working for oracle

Its a nice solution but can you explain this particular part

GROUP BY 1

It works fine but can you tell me how does it display the values 2-space seperated?

you don't use max then how your query able to output the max of the months*salary?

MS SQL

select top 1 salary*months, count(name) from employee
group by salary*months
order by 1 desc;

Very beautiful

This is not working in MySQL

In sql server its Top 1 in mysql its limit 1

can u please explain me why we group only salary not salary*months

Beautiful, my answer was very straight forward but not smart:

select max(salary*months), count(employee_id) from employee where salary*months = (select max(salary*months) from employee) group by salary*months

why have you used group by 1?

will not work if there is more than 1 employee with max salary

This answer is NOT reliable. "limit 1" will only show one MAX record - what if we have two or more records with the MAX earnings? Solution would be: select (salary * months) as earnings, count(*) from employee group by salary * months having earnings = ( select max(salary * months) from employee);

why shouldn't i use alias instead of 1

Just optimized solution-

select (salary * months) as earnings, count(*) from employee group by 1 desc limit 1;

Can you please explain why you need the order by earnings in addition to the group by 1? :)

my solution was the same but without the order by earnings

SELECT (MONTHS*SALARY) AS EARNINGS, COUNT(*) FROM EMPLOYEE GROUP BY 1 DESC LIMIT 1;

thanks bro

what is the meaning of count(*)

What about the part "2 space-seperated integers"? I was trying to use concat and add a space between them.

That is like my MS SQL solution:

SELECT top 1 (salary*months), count(*) FROM employee GROUP BY (salary*months) ORDER BY (salary*months) desc;

--groups the salaries by salary * month --then orders them from highest salary to lowest salary -- it counts how many is in each salary bracket -- as it puts them from highest to lowest, I can just do top 1 -- this returns count of people with highest potential salary

fantastic. I came up with this lame, complicated solution:

select maximum.earning, count( case when ((e.months*e.salary) >= maximum.earning) then 1 else 0 end ) from Employee e join ( select max(months * salary) as earning from Employee ) maximum on maximum.earning = e.months * e.salary group by maximum.earning;

hey here is my solution : select max(months*salary),count(months*salary) from employee where (months*salary) in (select months*salary from employee where months*salary = (select max(months*salary) from employee))

SELECT (SALARY MONTHS) AS EARNINGS, COUNT() FROM EMPLOYEE GROUP BY EARNINGS ORDER BY EARNINGS DESC LIMIT 1;

This reduces a lot of confusion, makes us understand what happens.

where is 2 space condition being met...

smart work!

you can use employee_id instead of * ...

genius solution

THIS IS AMAZING. THANK YOU.

Here is my somewhat similar Oracle solution:

select ms, (select count(employee_id) from employee where salary* months = ms) from (select max(salary* months) ms from employee);

could you please explain the code... thank you

        SELECT      Months * Salary, 

The MAX() around Earnings is extraneous, since that statement is already grouped by that figure.

Thanks

SELECT
    TOP 1 Months * Salary AS Earnings,
    COUNT(*)
FROM
    Employee
GROUP BY
    Months * Salary
ORDER BY
    Earnings DESC
;

select salary*months as earnings,count(*) from city --where earnings=(select max(earnings) from city); (or)

            select salary*months ,count(*) from city
            where  salary*months=(select max(salary*months) from city);

            why this too aren't working in oracle and how yours is working;
            @marinskiy 

Hello, why you add ROUNUM = 1;?

can you explain it?

yeah this solution is simple but not so semantic or obvious. Before looking at the discussions board I came up with this solution:

select max(earnings),count(employee_id) from( select earnings, employee_id,rank()over(order by earnings desc)rnk from( select max(months * salary) earnings, employee_id from employee group by employee_id )) where rnk=1;

why are we using count(*) in the query ?

how can we use 'salary*months as earnings' as far as i konw select statement will be executed after group by statement.

Hey what about the part of 2 spaced integer