Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display top 3 highest item price from item table

Posted By: Zak Brown     Category: Oracle     Views: 2227

This article provides an example to display top 3 highest item price from item table.

Code for Display top 3 highest item price from item table in Oracle

Select itemname from (select itemname from item orderby itemprice desc) where rownum<=3;

Output:

ITEMNAME     
----------    

Keyboard
Pendrive
Mouse
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Display top 3 highest item price from item table Or get search suggestion and latest updates.

Zak Brown
Zak Brown author of Display top 3 highest item price from item table is from London, United Kingdom.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!