SQL Select Statement

 The SELECTstatement has the following clauses:

Select distinct rows using DISTINCT operator.

Sort rows usingORDER BY clause.

Filter rows using WHERE clause.

Select a subset of rows from a table using LIMIT or FETCH clause.

Group rows into groups using GROUP BY clause.

Filter groups using HAVING clause.

Join with other tables using joins such as INNER JOIN, LEFT JOIN, FULL OUTER JOIN, CROSS JOIN clauses.

Perform set operations using UNION, INTERSECT, and EXCEPT.

Comments

Post a Comment

Popular posts from this blog

What is Tableau and important Role in details ?

Image
Tableau is a powerful data visualization and business intelligence software that allows users to connect different Sources, visualize, and share data in a way that facilitates understanding and decision-making. It is designed to help people see and understand their data by transforming raw data into an understandable format without requiring any technical skills.   Tableau's crucial role:   • Data Connection: Tableau can connect to various data sources (To a file: Microsoft Excel, Text File, JSON, PDF File… and To a Server: MySQL, Oracle, Microsoft SQL Server…), including spreadsheets, databases, cloud-based data, and more. It can handle large datasets and provides options for data blending and data cleansing.  • Data Visualization: Tableau enables users to create interactive and customizable visualizations such as charts, graphs, maps, and dashboards. Users can drag and drop elements to design visualizations without the need for coding.   • Dashboard Creation...
Read more