MySQL Forums
Forum List  »  Portuguese

Erro ao consultar
Posted by: FULVIO FULVIO
Date: March 13, 2023 02:19PM

Oi, sou novo por aqui, preciso de uma ajuda numa consulta no mysql.
Tenho uma tabela assim

DataAcesso | nome
01-01-2023 Fulano
02-01-2023 Fulano
01-01-2023 Beltrano
02-01-2023 Beltrano
02-01-2023 Beltrano

Quero uma consulta que retorne todos os nomes, mas a dataAcesso onde houver datas duplicadas quero somente um dos registros.
Só consigo fazer a consulta fazendo individual para cada nome.

Options: ReplyQuote


Subject
Views
Written By
Posted
Erro ao consultar
214
March 13, 2023 02:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.