This content has been marked as final. Show 2 replies
Oracle Version 18.104.22.168
I want to learn SQL and specifically row_number...over(partition by clause) and regexp function, because these clauses and functions are very much used into solve the sql questions. Kindly share your code in action with explanation and/or a good link, book to give me a start please. I tried to understand from docs, but simple example with explanation will help me to strengthen basics. Till now I have completed where, group by, having, order by clauses.