Posts by Ernane Sena • 11 points

• 0

  votes

  3

  answers

  1128

  views

  A: Oracle - Select distinct in one column only

  Well, if you are using Oracle 12c, there is a function that has been incorporated that can help you in your situation, specifically the "FETCH FIRST n ROWS" function, in this article it is possible…

  sql oracle

  answered 5 years, 9 months ago Ernane Sena 11

• 1

  votes

  2

  answers

  59

  views

  A: Problem running SQL

  Well if you use Oracle I see at least two alternatives to your question. You use Regular Expression and another solution would be to use the "substr" function to fetch the numbers and then sort…

  sql

  answered 5 years, 9 months ago Ernane Sena 11