Custom Search
www.rocket99.com : Technical Guides
Sybase
Oracle
UNIX
Javascript
Technical Guides
Sybase
Oracle
UNIX
Javascript
Of Interest
Business Intelligence and Analytics
Oracle Training
Oracle » PL-SQL » Coding » Ranking
Ranking Data
To display the rank, simply use the rownum variable.
-- Example: top 10 salaries
select rownum, salary, emp_name from employee where rownum < 10 order by salary desc
go
Oracle : Related Topics
Oracle : PL-SQL : Creating a stored procedure
Oracle : PL-SQL : Displaying output
Oracle : PL-SQL : Output variables
Oracle : PL-SQL : Arrays and structures
Oracle : PL-SQL : Conditionals
Oracle : PL-SQL : Looping in PL-SQL
Oracle : PL-SQL : Packages
Oracle : PL-SQL : Exception Handling
Oracle : PL-SQL : Sleep and Wait
Oracle : PL-SQL : Date Manipulation
Oracle : PL-SQL : Parallel Query Processing
Oracle : PL-SQL : Exit if error, in a SQL script
Oracle : PL-SQL : Cursors
Oracle : PL-SQL : Complex IF/THEN Processing
Oracle : PL-SQL : Creating triggers
Oracle : PL-SQL : How to do an outer join in Oracle
Oracle : PL-SQL : Loops in PL-SQL : Hierarchy
Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site
Get the latest Rocket99 news and tech tips via
Site Index
About this Guide to Sybase, Oracle, and UNIX
Contact Us
Advertise on this site
Copyright © 2016
Stoltenbar Inc
All Rights Reserved.
