MySql queries to find highest, second highest etc. values

By -
If we have a table 'account' with fields 'accountid' and 'balance',



1. Query to find highest balance from 'account' is:

 select balance from account order by balance desc limit 0,1;


2.  Query to find second highest balance from 'account' is:
  
select balance from account order by balance desc limit 1,1;
 

3.  Query to find third highest balance from 'account' is:

select balance from account order by balance desc limit 2,1;


    


Comments

Post a Comment

Popular posts from this blog

how to add new line in google form questions | Fix for next line issue in google form questions

By -
  Google forms are very useful to create online assessments and quiz. These are very to create through google forms. But there are some noted issues like when some questions are added line by line, it does not allow the new line by entering 'enter' key. So to make it work, there is a solution for that:  Follow this video for steps :  https://youtu.be/oTepX4VgSCI Code to be added: function addLineBreaks() {   var form = FormApp.getActiveForm();       // find form items you need    var questions = form.getItems(FormApp.ItemType.MULTIPLE_CHOICE);      for(i = 0; i < questions.length; i++)   {     var title = questions[i].getTitle();     questions[i].setTitle(title.split(". ").join("\n"));   } }
Read more

Coldfusion code to get multiple mail attachments using cfimap

By -
Below given code will loop through multiple attachments of the mail and will copy the attachments to particular folder. <cfimap action="open" connection="Conn" server="serverURL" username="useremail" password="password" secure="yes" port="portvalue"> <cfimap action="getall" connection="Conn" name="Query_getAttachments" folder="Inbox" attachmentpath="#GetTempDirectory()#" > <cfquery dbtype="query" name="getMailAttachments">       select *       from Query_getAttachments       where seen=<cfqueryparam value="no" cfsqltype="cf_sql_varchar">       and ATTACHMENTS is not null </cfquery> <cfdump var="#getMailAttachments#"> <cfloop query="getMailAttachments">       <cfif getMailAttachments.ATTACHMENTS NEQ ''>         <cfloop list="#ge...
Read more