SQL> select employee_id,salary from employees e where
2 2 =(select count(distinct salary) from employees where e.salary<=salary)
3 /
output
EMPLOYEE_ID SALARY
----------- ----------
101 17000
102 17000
all the best.....
2 2 =(select count(distinct salary) from employees where e.salary<=salary)
3 /
output
EMPLOYEE_ID SALARY
----------- ----------
101 17000
102 17000
all the best.....
sir plz guide me temporary table
ReplyDeletehow it will be useful to user and how it contain private data
and its commit components of rows
by jayank