Select Statement in Microsoft SQL Server ||Query || SQL||Select Statement

Select Query 

If you want to select all column from the Table 

Select Statement 👉    Select  * from TableName 


👉 (*)  Means     All


TableName      ?
👉  Any Table Name ,Which information do you wish to display?


If you want to select any particular Column.Select Statement 👉  Select Column1,Column2,Column3 from TableName👉 Column 1,Column2,Column3  Any Column which is available in the selected Table.

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

SQL Select Statement

  The   SELECT statement has the following clauses: Select distinct rows using  DISTINCT  operator. Sort rows using ORDER 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 .
Read more