[text] A

Viewer

  1. SELECT SUBSTR(Name, 0) AS name_SUBSTR,
  2.        INSTR('O', SUBSTR(Name, 0)) AS first_e_occurrence,
  3.        INSTR('O', SUBSTR(Name, INSTR('O', Name)+1)) AS second_e_occurrence
  4. FROM Employees
  5. WHERE INSTR('O', name) > 0;
  6.  

Editor

You can edit this paste and save as new:


File Description
  • A
  • Paste Code
  • 05 Jun-2023
  • 220 Bytes
You can Share it: