How to show data of the most recent date? [duplicate]

Question

Navigation

#1 by (5 votes)
#2 by (2 votes)

3

I have a table1:

I would like to see only the data with the most recent date. How do I?

php sql html

asked by anonymous 05.09.2016 / 11:31

2 answers

2

You can do this all in a single select:

SELECT * FROM tabela1 ORDER BY data DESC LIMIT 1

05.09.2016 / 19:51

score 5 · Accepted Answer

5

Try to:

SELECT * FROM tabela1 WHERE data = (SELECT data FROM tabela1 ORDER BY data DESC LIMIT 1);

05.09.2016 / 11:38