top-n

In 12c the FETCH clause allows you to do this select * from the_table order by value desc FETCH FIRST 1 ROWS WITH TIES; 4 solved SQL – How to select a row having a column with max value without using sub query in Oracle

Here the key is to get the count of Employee doing particular job in each department. In below query, this is achieved by subquery. Then, we want to get the Department with minimum no. of employee doing that job so we ordered the records returned by subquery in ascending and then select the first result … Read more