Posts by Ernane Sena • 11 points
2 posts
-
0
votes3
answers1128
viewsA: 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…
-
1
votes2
answers59
viewsA: 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…
sqlanswered Ernane Sena 11