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 BY
PNRao2013-07-01T00:00:00+00:00When 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.