ID RefNo Prefix Seq 179 55 I 1 180 55 A 1 182 55 A 2 183 55 A 3 184 56 A 1 181 56 I 1 187 56 A 2 188 56 A 3 189 59 I 1 190 59 A 1
ID RefNo Prefix Seq 183 55 A 3 188 56 A 3 190 59 A 1
SELECT * FROM ( SELECT row_number() OVER (PARTITION BY RefNo order by RefNo,Prefix ,Seq DESC) srno, ID, RefNo, Prefix, Seq from TableName ) as temp where srno = 1
GROUP BY
ID
SELECT RefNo, Prefix, MAX(Seq) AS Seq FROM TableName GROUP BY RefNo, Prefix
SELECT Last(Table1.ID) AS LastOfID, Table1.RefNo, Min(Table1.PreFix) AS MinOfPreFix, Max(Table1.Seq) AS MaxOfSeq FROM Table1 GROUP BY Table1.RefNo;
'LAST' is not a recognized built-in function name.
SQL, Server
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)