2 Replies Latest reply on Oct 1, 2013 5:26 AM by Ramin Hashimzadeh

    SQL Learning




      Oracle Version


      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.


      Thank you.