How to find the second highest salary from emp table ?
Select max(sal) from table_name where sal<(select max(sal)from table_name)Tags:
2nd highest salary2nd highest salary in sqlAccenture interview questions and answersAllstate Solut interview questions and answersCapgemini interview questions and answersCASTING NETWORKS INDIA PVT LIMITED interview questions and answersCGI Group Inc interview questions and answersChetu interview questions and answersCollabera Technologies interview questions and answersConduent interview questions and answersDell International Services India Pvt Ltd interview questions and answersfinding highest salary in the tableFIS Global Business Solutions India Pvt Ltd interview questions and answersFlipkart interview questions and answersGenpact interview questions and answersgetmaxhighest salaryhow to find max salary in sql without using max functionhow to find nth highest salary in sql server without using subqueryhow to find second highest salary in oraclehow to find second highest salary in sql using rank() functionhow to find second highest salary in sql using rownumhow to find second highest salary in sql using subqueryhow to find second highest salary in sql without using subqueryhow to find the second highest salary from emp tablehow to find third highest salary in sqlhow to find top 3 salary in sqlIBM interview questions and answersIndecomm Global Services interview questions and answersL&T Infotech interview questions and answersmax employmentmax functionmax inmax valueMindtree interview questions and answersMphasis interview questions and answersmysql maxmysql select topnth highest salary in mysqlnth highest salary in oracle using levelnth highest salary in sql server 2008nth highest salary in sql server using ctenth highest salary in sql server using row_numberOracle Corporation interview questions and answersoracle maxPersistent Systems interview questions and answersProkarma Softech Pvt Ltd interview questions and answersR Systems interview questions and answersSAP Labs India Pvt Ltd interview questions and answerssecond highest salarysecond highest salary in mysqlsecond highest salary in sqlselect maxselect max sqlselect name of employee with max salarysql findsql interview questionssql maxsql max datesql max functionsql query for nth highest salarysql query for second highest salarysql query to find highest salarysql query to find highest salary of employee in each departmentsql query to find nth highest salarysql query to find second highest salarysql query to find the second highest salary in the tablesql query to find third highest salarysql query to get second highest salaryTata Consultancy Service interview questions and answersTech Mahindra interview questions and answersUnitedHealth Group interview questions and answersValueLabs interview questions and answersVirtusa Consulting Services Pvt Ltd interview questions and answersWells Fargo interview questions and answersXoriant Solutions Pvt Ltd interview questions and answersyardi interview questions and answers
Other Articles
Previous
What is GUI Testing ?
Next
