Skip to main content

Find max and second max salary for a employee table MySQL

Simplest way to fetch second max salary & nth salary

"select 
 DISTINCT(salary) 
from employee 
 order by salary desc 
limit 1,1"
 
Note:

limit 0,1  - Top max salary
limit 1,1  - Second max salary
limit 2,1  - Third max salary
limit 3,1  - Fourth max salary

Comments

Post a Comment

Popular posts from this blog

Jquery form validation with ajax request

Include library <script src = "js/jquery.min.js" ></script> <script src = "js/jquery.validate.js" ></script> <?php $_SESSION [ 'code' ]= rand ( 1000 , 2000 ); ?>   <form name = "form-signup" id = "form-signup" method = "post" > <table width = "50%" > <tr> <td> Name </td> <td><input type = "text" name = "name" id = "name" class = "change" ></td> </tr> <tr> <td> Email </td> <td><input type = "text" name = "email" id = "email" class = "change" ></td> </tr> <tr> <td> Username </td> <td><input type = "text" name = "username" id = "username" class = "chan...
1 comment
Read more

Select Insert Update Delete With Image In Php MySQL

        CRUD with image upload is a very common task in web development ( CRUD stands for Create/Read/Update/Delete ). The main purpose of a CRUD is that enables user’s create/read/update/delete data using PHP & MYSQL. Table of Content Create Database Insert Record with image upload Show Record Edit Record Delete Record     
28 comments
Read more

PHP+AJAX+MYSQL: Sort & Save using Drag & Drop (TABLE TR)

" Drag, Drop, Sort, Save "  Drag & Drop : Move the draggable element by clicking on it with the mouse and dragging it anywhere within the viewport. Sor t: The sort order can be either alphabetic or numeric, and either ascending or descending.       Here we had created demo that allow the user to drag and drop elements and quickly  and save them with PHP + MySQL+ AJAX +JQUERY on the server side. Table of content 1) Drag and drop element on every click 2) Sort data on the server side using PHP+MYSQL 3) Great user interface and  easy to execute with a few lines of code    
24 comments
Read more