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 · 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

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

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

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

[sql] SQL grammar for SELECT MIN(DATE)

Examples related to sql