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.

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
;

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.

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?

I wanted to use rownum (Oracle) and came with sth like:

select * from
    (select earn, count(name) from 
        (select months*salary earn, name from employee)
    group by earn order by earn desc)
where rownum = 1;

Could it be simplified somehow? What do you think?

I think there is no need of first max.

Select salary*months, count(*)from Employee group by salary*months having salary*months=(Select MAX(salary*months)from Employee );

This one worked for me.