Home » RDBMS Server » Server Administration » HELP!!
HELP!! [message #374789] Mon, 02 July 2001 13:15 Go to next message
Chris
Messages: 128
Registered: November 1998
Senior Member
In Sql Server you can write a query like this:
SELECT a, b, c
FROM
(SELECT State AS a, SUM(Order_Amt) AS b, COUNT(*) AS c FROM Customer a, Orders b WHERE a.Account_No = b.Account_No)
WHERE State IN('MD','DC','VA')

I was wondering if I could do the same thing in oracle.

Report message to a moderator

Re: HELP!! [message #374790 is a reply to message #374789] Mon, 02 July 2001 15:11 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi

You can very well do it.

Report message to a moderator

Previous Topic: sqlplus core dumped
Next Topic: ORA-01843: not a valid month in C++ embedded SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 07:48:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.