SQL grammar for SELECT MIN DATE

Question

I have a table with structure  id INT PK   title VARCHAR   date DATE   How do I select all distinct titles with their earliest date   Apparently  SELECT DISTINCT title  MIN date  FROM table doesn t work

User · Accepted Answer

You need to use GROUP BY instead of DISTINCT if you want to use aggregation functions   SELECT title  MIN date  FROM table GROUP BY title

User · Answer

An aggregate function requires a GROUP BY in standard SQL  This is  Get minimum date per title  in plain language  SELECT title  MIN date  FROM table GROUP BY title   Most RDBMS and the standard require that column is either in the GROUP BY or in a functions  MIN  COUNT etc   MySQL is the notable exception with some extensions that give unpredictable behaviour

User · Answer

To get the titles for dates greater than a week ago today  use this   SELECT title  MIN date key no  AS intro date FROM table HAVING MIN date key no  gt   TO NUMBER TO CHAR SysDate   YYYYMMDD    - 7

User · Answer

SELECT  MIN Date   AS Date  FROM tbl Employee   To get First date Of Employee

[sql] SQL grammar for SELECT MIN(DATE)

Examples related to sql