tag:blogger.com,1999:blog-9075786158122089104.post536145737812317462..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: Find third highest salary from Employee tableRitesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-9075786158122089104.post-24330544988147027952012-12-24T08:19:07.542+05:302012-12-24T08:19:07.542+05:30Here is another way to find second highest salary ...Here is another way to <a href="http://javarevisited.blogspot.dk/2012/12/how-to-find-second-highest-or-maximum-salary-sql.html" rel="nofollow">find second highest salary in MySQL and SQ Server 2008</a>primary keyhttp://java67.blogspot.krnoreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-76233465753042764102011-07-05T17:14:50.275+05:302011-07-05T17:14:50.275+05:30Hi Fazal,
You are true....Hi Fazal,<br /><br />You are true....Ritesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-79228214521529499742011-07-05T16:39:43.362+05:302011-07-05T16:39:43.362+05:30Hi Ritesh,
We can find salary from following quer...Hi Ritesh,<br /><br />We can find salary from following query too:<br /><br /><br />select max(salary) from tblEmp<br />where salary not in (select top 2 salary from tblEmp order by salary desc )<br /><br />Thanks & Regards,<br />Fazal VahoraAnonymousnoreply@blogger.com