Course Hero Logo

newqueries5feb.txt - QUERY 17: SELECT...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 out of 1 page.

QUERY 17:SELECT Ename,Salary,Commission FROM EMP WHERE Commission>Salary*1.05;query 19:SELECT Eno,Ename,Salary,ROUND(Salary+(Salary*15/100),0) FROM EMP;QUERY 21:SELECT ENO,Ename FROM EMP WHERE Salary>(SELECT MAX(Salary) From EMPWHERE Job_type='Clerk');QUERY 24:SELECT Ename,LPAD(Salary,15,'$') Salary FROM EMP;QUERY 35:SELECT Eno,Ename,Salary FROM EMPWHERE Salary >(SELECT AVG (Salary) FROM EMP)AND Dno IN( SELECT DnoFROM EMPWHERE Ename LIKE '%T%');
End of preview. Want to read the entire page?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
Tanmoy
Tags
Prime number, SELECT ename, SELECT eno, EMP WHERE Commission

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture