PL/sql

Get new comments by email
You can cancel email alerts at anytime.
Comments (3)

ggorantla in Milwaukee, Wisconsin

30 months ago

How to write a PL/sql for the below question

Fetch the employee details who is earning min sal from emp table.
Print his name,deptno, salary along with his designation.

Rao

- Was this comment helpful? Yes (1) / No Reply - Report abuse

Ravi in Bangalore, India

30 months ago

Easy...

Select * from emp where sal = (select min(sal) from emp);

- Was this comment helpful? Yes (2) / No (5) Reply - Report abuse

Isha in Gurgaon, India

30 months ago

Select name, deptno, salary, designation
from emp where sal = (select min(sal) from emp);

- Was this comment helpful? Yes (2) / No (5) Reply - Report abuse

» Sign in or create an account to comment on this topic.