SQL Select Query for distinct latest record

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

I've a table with following structure & data.

SQL

Column1	Column2	Column3	Column4
220	    2	    1506	17
220	    1	    1506	15
218	    1	    1497	5
217	    2	    1499	10
217	    1       1601	11

I Want to select all records of column1 with latest column2 values.

i.e. my result should look like this:

SQL

Column1 Column2 Column3 Column4
220     2       1506    17
218     1       1497    5
217     2       1499    10

Please suggest.

Thanks & Regards,
Abhishek Kumar

Posted 19-Sep-14 0:40am

Abhishek Kumar (here to help!!)

Add a Solution

Comments

Mehdi Gholam 19-Sep-14 6:56am

... and what is the criteria for being "latest" ?

3 solutions

Solution 3

Here you have to make one self join to get the maximum value
Try this

select  Max(a.Column1)as Column1 , Column2 from table a inner join table b on a.Column2=b.Column2 group by Column2

hope this helps you
thanks

Posted 19-Sep-14 1:32am

Animesh Datta

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gihan Liyanage · Accepted Answer · 2014-09-19T01:06:00

Solution 1

See this thread.. with answer

http://stackoverflow.com/questions/16966415/sql-server-select-distinct-latest-values[^]

Posted 19-Sep-14 1:06am

Gihan Liyanage

_Asif_ · Accepted Answer · 2014-09-19T01:26:00

Solution 2

Try this

SQL

SELECT T.*
FROM
(
   SELECT Column1, Max(Column2) Column2
   FROM   TABLE
   GROUP BY Column1
) A INNER JOIN TABLE T on A.Column1 = T.Column1 AND A.Column2 = T.Column2

Posted 19-Sep-14 1:26am

_Asif_

SQL Select Query for distinct latest record

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

SQL Select Query for distinct latest record

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us