'SELECT FIRST 3 DISTINCT ORACLE 11g PLSQL [duplicate]

I have a table with 3 columns: id (PK), name, date

I only have 3 different names but the table is +1k records. So I need to get those 3 names ordered by date desc. But when I use the DISTINCT clause it brings all because the date are different.

I use a query like this:

SELECT DISTINCT (T.NAME) , T.DATE
    FROM TABLE1 T JOIN TABLE2 S ON T.ID = S.ID
   WHERE S.ROL = 3
ORDER BY T.DATE DESC;

dataa



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source