Solve this Sql Query

select salary from employee e1 where n =(select count(e2.salary) from employee e2 where e1.salary<=e2.salary);

Here In this case n=2(for 2nd largest)

select * from employee where (select max(salary) from employee where rownum=2);

ROWNUM works for Oracle. This query cannot be used across all the databases.

Display xyz(letters between - and -) from '123-xyz-abc' using sql or pl/sql

yes u r right goyal