4
Good day I need to bring only one product per affiliate, but in my table I have several times the same product just changing the date, I would like to take the product of the last date.
What do I have:
SELECT ID, CODFIL, DT, COLUNAVARIANTE FROM X;
Upshot:
ID CODFIL DT COLUNAVARIANTE 1 1 XXXXX X 1 1 YYYYY Y 1 2 XXXXX X 1 3 XXXXX
What I need
ID CODFIL DT COLUNAVARIANTE 1 1 XXXXX X 1 2 XXXXX X 1 3 XXXXX X
1
The query below should bring you what you need:
SELECT ID, CODFIL, max(DT)
FROM X
GROUP BY ID, CODFIL
Thus, you will have only the longest date for each returned product.
Yes, indeed, forgive me for my mistake but I had not put the column variant in the select "SELECT ID, CODFIL, DT, COLUNAVARIANTE FROM X; " in this case put the max will not meet me
Browser other questions tagged sql sql-server select
You are not signed in. Login or sign up in order to post.
You need this: #Select first record within a segmentation in SQL Server See function: #Sqlfiddle
– Marconi
Take a look at my answer!
– Marconi
Excellent @Marconi !!
– Gabriel Souza
Excellent!! Thank you very much!
– Gabriel Souza
of nothing, gives a read on the question that Linkei about. I have an answer there that has 3 ways to do this!
– Marconi