vivek singh

• May 1st, 2007

 

Yes we can find out nth highest of m values where n
select x from (select rowid y ,   x from table_name order by column_1) where
n= y;

jsubha2009

 Profile Answers by jsubha2009 Questions by jsubha2009

• Nov 24th, 2009

 

 We can find the 3rd max out of 4 given numbers by checking the least greatest of the least greatest number.if to say in T-SQL:

select top 1 max(numbers) from tables where tables a1 join tables b1 on a1.numbers< b1.numbers

select top 1 from tables t where t.numbers >ALL(select top 499 from tables s order by s.numbers desc) order by t.numbers asc

Codd rules specify about Normalization and Denormalization techniques for relational Tables and Databases to be utilized to the full extent.