Manish Manish - 1 year ago 64
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 Source
select * from table_name where date = (select max(date) from table_name);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download