skip to main | skip to sidebar

Jack of PHP trades

A place for technical stuff like php, sql, postgres, mysql, javascript, ajax etc with day to day updates and all other exciting stuff. Know how stuff works. Be it a beginner or an experienced Or rather be it a problem, bug or for any interview.

Monday, May 10, 2010

Need to find second highest salary from table

Ok..i know there are various methods to do this...but was looking for optimized query to find the second highest salary from say..employee table that has id, Name and Salary as fields! Can i do it in one query?? Help!!!
Posted by Shashank at 12:13 AM 0 comments
Labels: how to find the second highest salary from emp table?, mysql, postgres, query, query optimization, second highest, sql
Older Posts Home

Blog Archive

  • ▼  2010 (7)
    • ▼  May (2)
      • Need to find second highest salary from table
      • Cursor:hand not working with mozilla/firefox/chrom...
    • ►  April (5)
      • PHP Cookies
      • Selecting from a sub-query
      • A simple sub-query - subquery return one value
      • Why are docx, xlsx, pptx downloading from webserve...
      • How to Install Google Analytics on Blogger