How to find the second highest salary from emp table ?<\/h2>\n<\/div>\n<\/div>\n

\n

\n

\n

Select<\/span> max<\/span>(sal) from table_name where sal<(select<\/span> max<\/span>(sal)from table_name)<\/span><\/code><\/strong><\/pre>\n<\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Answer : Select max(sal)…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[6547],"tags":[6592,6590,195,6595,203,199,214,198,209,283,205,6584,2936,222,484,6571,6576,6548,6549,6550,6551,6552,6553,6554,6583,6555,6556,196,212,286,6568,6582,6579,6567,970,207,6572,6575,6557,6558,6559,6560,6561,204,6580,282,208,288,206,6569,6562,6570,6581,6573,6563,6578,6565,6566,6574,6577,6591,6587,6593,6564,6589,6586,6585,6588,6594,975,200,197,284,280,364,285,15882],"class_list":["post-955","post","type-post","status-publish","format-standard","hentry","category-sql","tag-2nd-highest-salary","tag-2nd-highest-salary-in-sql","tag-accenture-interview-questions-and-answers","tag-allstate-solut-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-chetu-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-conduent-interview-questions-and-answers","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-finding-highest-salary-in-the-table","tag-fis-global-business-solutions-india-pvt-ltd-interview-questions-and-answers","tag-flipkart-interview-questions-and-answers","tag-genpact-interview-questions-and-answers","tag-getmax","tag-highest-salary","tag-how-to-find-max-salary-in-sql-without-using-max-function","tag-how-to-find-nth-highest-salary-in-sql-server-without-using-subquery","tag-how-to-find-second-highest-salary-in-oracle","tag-how-to-find-second-highest-salary-in-sql-using-rank-function","tag-how-to-find-second-highest-salary-in-sql-using-rownum","tag-how-to-find-second-highest-salary-in-sql-using-subquery","tag-how-to-find-second-highest-salary-in-sql-without-using-subquery","tag-how-to-find-the-second-highest-salary-from-emp-table","tag-how-to-find-third-highest-salary-in-sql","tag-how-to-find-top-3-salary-in-sql","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-max-employment","tag-max-function","tag-max-in","tag-max-value","tag-mindtree-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-mysql-max","tag-mysql-select-top","tag-nth-highest-salary-in-mysql","tag-nth-highest-salary-in-oracle-using-level","tag-nth-highest-salary-in-sql-server-2008","tag-nth-highest-salary-in-sql-server-using-cte","tag-nth-highest-salary-in-sql-server-using-row_number","tag-oracle-corporation-interview-questions-and-answers","tag-oracle-max","tag-persistent-systems-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-r-systems-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-second-highest-salary","tag-second-highest-salary-in-mysql","tag-second-highest-salary-in-sql","tag-select-max","tag-select-max-sql","tag-select-name-of-employee-with-max-salary","tag-sql-find","tag-sql-interview-questions","tag-sql-max","tag-sql-max-date","tag-sql-max-function","tag-sql-query-for-nth-highest-salary","tag-sql-query-for-second-highest-salary","tag-sql-query-to-find-highest-salary","tag-sql-query-to-find-highest-salary-of-employee-in-each-department","tag-sql-query-to-find-nth-highest-salary","tag-sql-query-to-find-second-highest-salary","tag-sql-query-to-find-the-second-highest-salary-in-the-table","tag-sql-query-to-find-third-highest-salary","tag-sql-query-to-get-second-highest-salary","tag-tata-consultancy-service-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-unitedhealth-group-interview-questions-and-answers","tag-valuelabs-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers","tag-yardi-interview-questions-and-answers"],"yoast_head":"\n