We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
When you use MIN/MAX in select statement, it will return a single row from the table with the LOWEST/HIGHEST value element from EACH column.
With GROUP BY clause, it will return the LOWEST/HIGHEST value element from each column and EACH group. Refer to the image attached on my main thread and connect this comment. You will get it.
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Occupations
You are viewing a single comment's thread. Return to all comments →
min/max because we do not want the NULL elements.
When you use MIN/MAX in select statement, it will return a single row from the table with the LOWEST/HIGHEST value element from EACH column.
With GROUP BY clause, it will return the LOWEST/HIGHEST value element from each column and EACH group. Refer to the image attached on my main thread and connect this comment. You will get it.