Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Comparing the field values and return the row

Hi, I have table with 3 fields

COL1, COL2 and COL3

COL3 having values 1 or 0 for all the records in a table.

Suppose COL2 having value AB which is having 1 and 0 as values of COL3 that means 2 records. from these 2 records i need to retrieve one record based on COL3 value.

in this case i need to PIck where the COL3 =1

suppose the COL2 having only one value with COL3 having 0 then i need to consider that one

Please help me how to get this in sql

Capture.PNG (4174 B)
Former Member
Former Member replied

ThanksĀ  a lot for your valuable suggestions.

I got this in the query using window function.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question