Help | Site Map

Join Bytes
Login

network: 226,272 (1535 online)

bytes

how to find the seventh largest number in a column

karthickkuchanur karthickkuchanur is offline

karthickkuchanur is offline

Familiar Sight

Join Date: Dec 2007

Posts: 135

#1: Sep 22 '08

how to find the seventh largest number in a column
for example
1,2,3,4,5,6,7

debasisdas debasisdas is offline

debasisdas is offline

Moderator

Join Date: Dec 2006

Location: Bangalore ,India

Posts: 7,500

#2: Sep 22 '08

re: how to find the seventh largest number in a column

try to use rownum after sorting the column.

Reply

« previous question | next question »

Similar Oracle Database bytes

Write a program to find and print a Fibonacci sequence of numbers in assembly (answers)
Determine largest value in table column (answers)
Sort/find minimum value in row entries (answers)
Where do I find out more? (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved