How to find the second highest salary from emp table ?
Select max(sal) from table_name where sal<(select max(sal)from table_name)Related Tags
- 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
