Sorting and Grouping the Data in SQL – ORDER BY GROUP BY

Home/SQL/Sorting and Grouping the Data in SQL – ORDER BY GROUP BY

When we are dealing with huge data, we can not analyse the data by looking into each record. We sort and group the data based on certain variables and understand the data. We use Order By, Group by,Where and Having Clauses to Sort and group the data in SQL.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


Following are detailed examples to explain ORDER BY GROUP BY clauses in SQL.

Sorting in SQL:

Order By clause sort the result set from the query (with a where clause) in a specific order using the ORDER BY clause based on specified column(s).

Syntax:

Here is the syntax of Order By clause in SQL.

[code lanuage=”sql”] Select columns
From tables
Where <condition>
Order By column ASC/DSC;

ASC option sort the data in Ascending order and DSC option sort the selected data in Descending Order.

Example:

Here is the example to sort the data based on the Department variable. It fetches the data from Employee table and sort the data EID,NAME,Salary,Department based on Department.,[code lanuage=”sql”] SELECT EID,Name,Salary, Department
FROM Employee
ORDER BY Department ASC;

Grouping in SQL:

SQL Group By clause is used to retrieve data grouped according to one or more columns.

Syntax:

Here is the syntax of Group By clause in SQL.

[code lanuage=”sql”] Select columns
From tables
GROUP BY column;

Example:

The following example group the data based on Department. It fetches the data from Employee table and sort the data based on Department Variable.[code lanuage=”sql”]

SELECT Department, Sum(Salary)
FROM Employee
GROUP BY Department;

If you want to use Group By with a aggregated function do not use Where Clause, use Having Clause.
The reasons are:
WHERE applies to each and single row and HAVING applies to summarized rows. HAVING clause fetch the data first and then separated according to condition.HAVING is used only with the SELECT statement and WHERE Clause can be used other than Select statement also.WHERE is used before GROUP BY clause, HAVING is used after GROUP BY clause.

LIMITED TIME OFFER
By |July 1st, 2013|SQL|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment


Related pages


sumif example in excelvb 6.0 interview questions and answers for experiencedcomplicated excel functionsexcel formulas sumifvlookup definitionhow to unlock a excel file protected by passwordvbscript sql server connectionpricing model template in excelexcel combo box propertiesvlookup in excel examplesexcel vba average functionlookup and reference in excelhow to create a pivot table in excel 2003estimating templateshow do i copy cells in excelhow to unhide all columns in excelvba function excelvba cell font colorrecord excel macrocopy data from multiple worksheets into oneautomation testing interview questions and answers for fresherswhile loop in excel vbahow to combine duplicate rows in excelexcel macro option buttonnested vlookup functionmacro excel vbaexcel vba dynamic arrayhow do i hide columns in excelexcel vba change column widthsas language basicsvba macros in excel 2007 tutorials pdfexcel if statement with 2 conditionsexcel hyperlinkif iserrorexcel vba rangevba userform listboxvba workbooks openinsert check boxiserror excel functionvba excel pastespecialexcel vba count rowsexcel vlookup truevlookup explanationsql basic commands with examplesmysql adodb connection stringcomplex macros in excelhow to unhide all sheetsworkbook worksheetsadodb sql server connection stringcopy tabs in excelvba file browservisual basic sample codes for beginnerstask tracking spreadsheet templatewhat is vba programmingfree capacity planning template excelpassword protect cells in excelexcel 2003 macrosvba for modelersmacro excel insert rowvba basic tutorialoffset meaning in hindibar chart schedule in excelboard meeting minutes template microsoft wordsql basics interview questions and answers pdfvba class examplebasic vba codeexcel highlight duplicatestextcasefind duplicates in excel 2010clear duplicates in exceldefine workbook and worksheetexcel insert worksheetarrays excel vbasas coding basicsunlock excel sheetsas sql tutorialexcel vba until