How to use four clause in one query

Get records using with joins, where,group by, having and order by clauses

FROM & JOINs determine & filter the selected rows
WHERE more filters on the rows to desire columns
GROUP BY combines those rows into groups like 1,1,1,2,2,3 result: 1,2,3
HAVING filters groups using to aggregate functions
ORDER BY arranges the remaining rows/groups to order wise ascending or descending order

Comments

Post a Comment

Popular posts from this blog

Add Image through base64 on PDF in itextsharp

If you have base64 code image or image path, easily can add image in PDF from iTextSharp. Code below: PdfReader pdfReader =  new  PdfReader( "C:\\file.pdf" ); PdfStamper pdfStamper =  new  PdfStamper(pdfReader,  new  FileStream( "target save path" , FileMode.Create)); string  imagepath =  "base64 image code" ; Byte[] bytes = Convert.FromBase64String(Regex.Replace(imagepath, @ "^data:image\/[a-zA-Z]+;base64," ,  string .Empty)); var  pdfContentByte = pdfStamper.GetOverContent(1);  // page number iTextSharp.text.Image image1 = iTextSharp.text.Image.GetInstance(bytes); image1.SetAbsolutePosition(140, 70); image1.ScalePercent(20f); pdfContentByte.AddImage(image1); pdfStamper.Close();
Read more

Set span value using jquery and javascript

Solved: Jquery Example: you can set value two different function. 1- text(); 2- html(); $ ( "#submittername" ). text ( "testing" ); $ ( "#submittername" ). html ( "testing <b>1 2 3</b>" ); Difference between text and html functions text - you can set only value html - you can set value with html code but html tags not necessary for set the value JavaScript Example; you can set value from innerHTML document. getElementById ( "spanID" ).innerHTML. ( "testing" );
Read more

how to insert text and tags at the cursor CKEDITOR

//change all "IDofEditor" to the id of your editor; I haven't figured out how to find it less explicitly //insert text CKEDITOR . instances . IDofEditor . insertText ( 'some text here' ); //insert a link (or other tags, modify as needed) //this example uses the selected text for the link text //if removing getSelection() and just inserting it all, you MUST have some link text or it will NOT insert; also if the user selected text first anyway it will change it to "NaN". //the \x22 represents a double quote, thus easy to use within an html onclick //getNative() gets the text, otherwise you get an object CKEDITOR . instances . IDofEditor . insertHtml ( '<a href=\x22my_link\x22>' + CKEDITOR . instances . IDofEditor . getSelection (). getNative () + '</a>' ); //you could also prompt the user for the link text (and title and link or anything else); very fast entry! CKEDITOR . instances . IDofEditor . insertHtml ( ...
Read more