Recent content by Tester09

r937, thanks. Your code works.

Thanks PHV and r937.

55 Z 123" is the last row with 55 in Column A, then "09 S 123" is the last row with 09 in Column A. They are sorted by Column A and then Process_Time(let's say it's in Column D). Thanks.

Sorry for the confusion. Column: A B C Data : 55 S 123 Data : 55 T 123 Data : 55 Z 123 Data : 09 S 123 Data : 09 T 123 Data : 09 S 123 I sorted the result so what I want is "55 Z 123" and "09 S 123" out of the above table. I have created a view so the original statement does...

Thanks for your reply. My example is not a table, it is a result of the select statement. Probably I should create a view and try again. Column: A B C Data : 55 S 123 Data : 55 T 123 Data : 55 Z 123 Data : 09 S 123 Data : 09 T 123 Data : 09 S 123 Just for clarification: I want...

Hi, I have the following result from a select statement: Column: A B C Data : 55 S 123 Data : 55 T 123 Data : 09 S 123 Data : 09 T 123 I am new to SQL and I cannot figure out a way to do the following: "If there are rows with same values in Column A, select the rows with 'T' in...