SQL helps Analysts to perform ETL transactions on required data set in data analysis tasks. We can extract the data from data base, format the data, summarize and analyze it.
Sorting and Grouping the Data in SQL – ORDER BY GROUP BYPNRao2013-07-01T00:00:00+00:00
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.