oracle sql hero's, please come here

[Pitta]

2 minutes ago, ARYA said:

fittaa  

corona season lo non veg tinnodu telusu kada 

[ARYA]

1 minute ago, Pitta said:

corona season lo non veg tinnodu telusu kada 

full ga fire lo gattiga masala petti BBQ sestaa telsu ga

[Pitta]

5 minutes ago, ARYA said:

full ga fire lo gattiga masala petti BBQ sestaa telsu ga

bat kuda pakshe anukoni tinnaru anta china vallu anduke corona ochindi 

[ring_master]

31 minutes ago, Rabbo said:

i got it by using 

 

select customer_id,product_id,customer_product_id,order_date
from   ( select customer_id,product_id,customer_product_id,order_date, rank() over 
(partition by customer_id,product_id  order by order_date desc) as rnk
         from   table t
       )
where  rnk = 1

Asalu window function use cheyalsina avsaram em vndi....Order date tho sort chesi limit 1 pedite ade vastadi kadaaa

[ARYA]

25 minutes ago, Pitta said:

bat kuda pakshe anukoni tinnaru anta china vallu anduke corona ochindi 

bat pakshi kadu mammal 

[vokatonumberkurrodu]

use oracle analytical function rownumber() over (partition by key fields order by date desc)

and select all records where this value is 1.