How to display the names of employees whose names have second alphabet A in their names?

Oracle Apps Interview Questions › Category: SQL › How to display the names of employees whose names have second alphabet A in their names?
0 Vote Up Vote Down
Questions Master asked 10 years ago

How to display the names of employees whose names have second alphabet A in their names?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

SELECT ename FROM emp WHERE ename LIKE ‘_A%’;