Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to get top 5% of account
- Thread starter natncm70
- Start date
V2R3+:
select account_balance
from accounttable
qualify
quantile(100, account_balance desc) <= 5
V2R4.1+:
select account_balance
from accounttable
qualify
percent_rank() over (order by account_balance desc) <= 0.05
Percent_rank is SQL:1999 whereas quantile is a Teradata extension.
Dieter
select account_balance
from accounttable
qualify
quantile(100, account_balance desc) <= 5
V2R4.1+:
select account_balance
from accounttable
qualify
percent_rank() over (order by account_balance desc) <= 0.05
Percent_rank is SQL:1999 whereas quantile is a Teradata extension.
Dieter
- Status
Similar threads
- Locked
- Question