Let me explain the question in detail.
Period1 - SEQ - Column1 - Column2
1- 1211212 - value1 - valu2
1- 122322 - value3 - value4
2 - 3434343- value5 - value6
2 - 344323 - value7 - value8
I want to pull the max(seq) for all the distinct periods. I need these details to compare to other table too. Please help me out.