خرید بک لینک

Vote count: 0

I have a table X

    ID    A     B
    --------------
    1    abc    27
    1     -     28
    2     -     33
    3    xyz    41
    3     -     07

I need output as

    ID    A     B
    --------------
    1    abc    27
    2     -     33
    3    xyz    41

I tried doing

max(A) OVER (PARTITION BY ID) as the_value

but it did not work. I can still see all the rows in the output table.

I was wondering if somebody has come across a similar situation and has a solution to this ?

asked 1 min ago

- - , .

برچسب: نویسنده: استخدام کار تاريخ: سه شنبه 18 اسفند 1394 ساعت: 7:29

صفحه بندی