asked
Filter data in a table
Dears i have table that contains the following columns: ======================================================================================= ![alt text][1] --------------------------------------------------------------------------------------------- i need to filter the data in another table to be like the following result: --------------------------------------------------------------------------------------------- ![alt text][2] as you see with condition if charcater repeated select highest ID. [1]: /storage/temp/4201-input.jpg [2]: /storage/temp/4202-output.jpg
DECLARE @T table (ID int identity, Type varchar(5)) insert into @T(Type) values ('A'),('11'),('22'),('33'),('B'),('44'),('55'),('C'),('D'),('55'),('66'),('E'),('F'),('G'),('77'); with cte as (select * from @t where ascii(TYPE) between 65 and 90) select
t.id , ( select type from cte where id = (select max(id) from cte where id <
t.id) ) Type, t.Type value from @t t where id not in (select id from cte)
18 People are following this question.
