Manish Manish - 5 months ago 8
SQL Question

SQL query for extracting multiple rows with single date entry

I have a table "T" that contains Date as one of the column.

In the table, there are multiple rows associated with single date entry.

I want an query that will give me all the rows associated with the latest date available in the table.

Answer
select * from table_name where date = (select max(date) from table_name);
Comments