Search:
www.rocket99.com : Technical Guides
Sybase
Oracle
UNIX
Javascript
Technical Guides
Sybase
Oracle
UNIX
Javascript
After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures
!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent
Friday fish fry
!
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 Mobile Web Site
Oracle Web Site
Site Index
About this Guide to Sybase, Oracle, and UNIX
Contact Us
Advertise on this site
Copyright © 2008
Citisoft Inc
All Rights Reserved.