Manish Manish - 10 months ago 28
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.

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