Calculate second min and max row values average in SQL

select (  (  (select row_name from table_name order by row_name desc limit 1,1) + (select row_name  from
table_name order by  row_name asc limit 1,1) )/2) as average from table_name ;