Select max(sal) from table_name where sal<(select max(sal)from table_name)

Tagged in:

2nd highest salary, 2nd highest salary in sql, Accenture interview questions and answers, Allstate Solut interview questions and answers, Capgemini interview questions and answers, CASTING NETWORKS INDIA PVT LIMITED interview questions and answers, CGI Group Inc interview questions and answers, Chetu interview questions and answers, Collabera Technologies interview questions and answers, Conduent interview questions and answers, Dell International Services India Pvt Ltd interview questions and answers, finding highest salary in the table, FIS Global Business Solutions India Pvt Ltd interview questions and answers, Flipkart interview questions and answers, Genpact interview questions and answers, getmax, highest salary, how to find max salary in sql without using max function, how to find nth highest salary in sql server without using subquery, how to find second highest salary in oracle, how to find second highest salary in sql using rank() function, how to find second highest salary in sql using rownum, how to find second highest salary in sql using subquery, how to find second highest salary in sql without using subquery, how to find the second highest salary from emp table, how to find third highest salary in sql, how to find top 3 salary in sql, IBM interview questions and answers, Indecomm Global Services interview questions and answers, L&T Infotech interview questions and answers, max employment, max function, max in, max value, Mindtree interview questions and answers, Mphasis interview questions and answers, mysql max, mysql select top, nth highest salary in mysql, nth highest salary in oracle using level, nth highest salary in sql server 2008, nth highest salary in sql server using cte, nth highest salary in sql server using row_number, Oracle Corporation interview questions and answers, oracle max, Persistent Systems interview questions and answers, Prokarma Softech Pvt Ltd interview questions and answers, R Systems interview questions and answers, SAP Labs India Pvt Ltd interview questions and answers, second highest salary, second highest salary in mysql, second highest salary in sql, select max, select max sql, select name of employee with max salary, sql find, sql interview questions, sql max, sql max date, sql max function, sql query for nth highest salary, sql query for second highest salary, sql query to find highest salary, sql query to find highest salary of employee in each department, sql query to find nth highest salary, sql query to find second highest salary, sql query to find the second highest salary in the table, sql query to find third highest salary, sql query to get second highest salary, Tata Consultancy Service interview questions and answers, Tech Mahindra interview questions and answers, UnitedHealth Group interview questions and answers, ValueLabs interview questions and answers, Virtusa Consulting Services Pvt Ltd interview questions and answers, Wells Fargo interview questions and answers, Xoriant Solutions Pvt Ltd interview questions and answers, yardi interview questions and answers