Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Queries

4243516Sep 18 2020 — edited Sep 18 2020

Hi All,

Please help me with the queries for below scenarios considering employees table.

  1. Employees whose salary is greater the avg salary of all employees?
  2. SQL query to find the employees which have continuous increase in salary every year?
  3. SQL query to find the employees which does not have any hike at all in that year?
  4. SQL query to find the products whose sales decreased in 2020 compared to 2019?

Thanks,

Twinkle
Comments
Post Details
Added on Sep 18 2020
5 comments
332 views