How can i retirve second largest value from the table?

Question

For e-g a table consist of values like 80,45,90,60,70.I need a query tht will fetch only the value 80.

Answer 1

why only second higest, i'm giving u a query by which u can find n'th higest number, simply put the number in place of 'n'

select min(fldName) from tblName Where fldName in (select top n sal from tblName order by fldName desc)

Answer 2

The correlation coefficient between 2 random variables: a. Is a volume between -a million and a million d. Is envisioned in Excel via way of becoming use of function CORREL the median is: d. the nicely worth that diveide the understanding sequence into 2 equivalent components

Answer 3

This is depend upon what database you have. In MySQL you can set the start- and the endpoint. in SQL you would just say
Select Top 1 FieldSeconds from TableName
Order By FieldSeconds DESC
Having FieldSeconds < MAX(FieldSeconds)

Helmut

Answer 4

Why not sort them numerically, largest first, pop them into a 'holding area' (small table maybe?), and take the second value?

Gary

Answer 5

select col-name from tab-nam orderby asc where rowid=2;

Answer 6

select max(column_name) from table t1 where t1.column_name<(select max(column_name) from table);

cool way....