Select all the employees who were hired in last 2 years and who works in dept

Select all the employees who were hired in last 2 years and
who works in dept where max managers are working.

Question Posted / manikanth

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

Explain constraining triggers.

What is system global area (sga) in oracle?

What is hash cluster in oracle?

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

What happens in oracle commit?

Explain an integrity constrains?

how to get the no employee in each department including the dept which has 0 employee

How do we display rows from the table without duplicates?

What is not equal to in oracle?

Can u make a synonym for deptno=10 only from emp table.

How to initialize variables with default values?

For more Oracle General Interview Questions Click Here