Home » SQL & PL/SQL » SQL & PL/SQL » SQL STATEMENT FOR CALCULATION
SQL STATEMENT FOR CALCULATION [message #256079] Thu, 02 August 2007 23:20 Go to next message
Ora_ardor
Messages: 9
Registered: March 2006
Location: PAKISAN
Junior Member
Hi,

I want to know that how can I find the Max three salries
in EMP table of scott schema and furthemore, is it possible
to calculate a running total on sql as below

sal rtot
10 10
15 25
50 75

I mean can write a query for rtotal column

Regards
ASIF

asif_link@yahoo.com



[Updated on: Thu, 02 August 2007 23:21]

Report message to a moderator

Re: SQL STATEMENT FOR CALCULATION [message #256084 is a reply to message #256079] Thu, 02 August 2007 23:57 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Search this forum for "TOP N".

Re: SQL STATEMENT FOR CALCULATION [message #256089 is a reply to message #256079] Fri, 03 August 2007 00:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Top N questions are very often asked.
This one is closed.
./fa/448/0/
Regards
Michel
Previous Topic: issue with quotes
Next Topic: Replacing a particular charater in the data being displayed
Goto Forum:
  


Current Time: Sun Dec 04 00:33:29 CST 2016

Total time taken to generate the page: 0.08249 seconds