Forum: Other

Post: rank-qualify

rank-qualify
tcallaghan
Jan 30, 2011
Can you please provide more information on your question, like including the SQL you'd use in your existing database?
-Tim
rank-qualify
desaiak
Jan 30, 2011
Are qualify-rank kind of sql's supported ?
If yes how are they proocessed - single or multi partitioned ?
desaiak
Jan 31, 2011
select net_amt as rank_val
qualify row_number() over ( order by rank_val asc) between 1 and 5query
re: rank-qualify
tcallaghan
Jan 31, 2011
select net_amt as rank_val
qualify row_number() over ( order by rank_val asc) between 1 and 5query


This SQL functionality will need to be implemented in Java in your stored procedures. As we enhance our SQL support over time we will be focusing areas that provide the most improvement to OLTP workloads.

-Tim