Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Little problem
Oracle Little problem [message #38202] Mon, 01 April 2002 04:13 Go to next message
Prem chand
Messages: 1
Registered: April 2002
Junior Member
see you would have seen Emp table in scott user
Now if I fires one query then I should be able to get the sum(sal) of all the employees under that manager

Report message to a moderator

Re: Oracle Little problem [message #38213 is a reply to message #38202] Tue, 02 April 2002 00:57 Go to previous message
Yuvraj Thapa
Messages: 28
Registered: May 2001
Junior Member
select sum(sal),mgr from emp group by mgr

Report message to a moderator

Previous Topic: How to find out which database I am using from the SQL Promt??
Next Topic: insert Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 15:56:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.