Re: Help SQL question (Calculation)
When the TRUNCATE statement is executed it will remove all the rows.
Syntax :TRUNCATE TABLE table_name
If we remove the TRUNCATE statement then the rows did not delete.
we can use the ties ordering the rank.This will give rank in each item in the table
Eg:SELECT TOP 3 FROM table ORDER BY Value WITH TIES
Subject
Written By
Posted
Re: Help SQL question (Calculation)
August 19, 2014 01:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.