showing top x values in sql*plus

From: Chrissy <chrissysjunk_at_yahoo.co.uk>
Date: 26 May 2003 17:49:24 -0700
Message-ID: <de060d08.0305261649.71155d69_at_posting.google.com>

does anyone know how to display the top 3 values of data retrieved from a table rather than all the values?

thanks in advance

chrissy Received on Tue May 27 2003 - 02:49:24 CEST

This message: [ Message body ]
Next message: Dimitri Ang: "Re: Oracle SQL: UPDATE using Subquery or Join"
Previous message: Dave: "HELP: Adding date to spool filename using SQLplus"
Next in thread: Maximus: "Re: showing top x values in sql*plus"
Reply: Maximus: "Re: showing top x values in sql*plus"
Reply: http://www.webyourcompany.com: "Re: showing top x values in sql*plus"
Reply: Tim X: "Re: showing top x values in sql*plus"
Maybe reply: Peter Myers: "Re: showing top x values in sql*plus"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message