id name mid =========== 1 A null 2 B 1 3 C null 4 D 1
var c = (from x in olist order by mid descending select mid).Distinct().Skip(1).First();
int secondHighest = (from Id in MyTable orderby Id descending select Id).Skip(1).First();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)