please solve this pblm in different different ways. plz solve it..
716839Aug 20 2009 — edited Aug 20 2009following are the query for default database which is stored in oracle.
tablenames--emp and salgrade.
query--> select the name of employee along with their salary and grade.
one solution is.
sql> select e.ename, e.sal, s.grade from emp as e, salgrade as s
where e.sal>=s.losal and e.sal<=s.hisal;
please try it in different manner.
Edited by: user8710598 on Aug 20, 2009 10:36 AM