Skip to content
Advertisement

Tag: analytical

Oracle Analytical Function?

For the given table below, how can we find the customer whose name appears 3 times consecutively. Desired_Output Table Definition: Code Tried so far I believe we can do this by using lead/lag to get the previous and next row. Although my solution gives the desired output but i don’t think this is correct solution. Answer Your method is close.

Advertisement