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: 26766
Registered: January 2009
Location: SoCal
Senior Member
Search this forum for "TOP N".

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Top N questions are very often asked.
This one is closed.
/forum/fa/448/0/
Regards
Michel

Report message to a moderator

Previous Topic: issue with quotes
Next Topic: Replacing a particular charater in the data being displayed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 10 03:06:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.