SELECT



SQL Server SELECT Query

SELECT statement is used to fetch the data from database table.

Basic syntax of select statement
-- example
SELECT column1, column2, columnN FROM table_name;

EXAMPLE

Below is the Person Table with Data


IDNameAgeAddressSalary
1Keerthana24Hyderabad10,000
2Madhav22Mumbai8500

Following is an example, which fetches data rows based on the column names from the Person table:


SELECT ID, NAME, SALARY FROM Person;

This would produce the following result

IDNameSalary
1Keerthana10,000
2Madhav8500

Following is an example, to fetch all data rows with asterisk (*) wildcard character from Person Table.


SELECT * FROM Person

This would produce the following result


IDNameAgeAddressSalary
1Keerthana24Hyderabad10,000
2Madhav22Mumbai8500


Connection String

SQL Server Connection String Formats

posted on 2019-08-27 05:53:53 - SQL Server Tutorials


UNION

union in SQL server

posted on 2019-08-09 23:05:33 - SQL Server Tutorials


System Functions

System Functions in SQL Server

posted on 2019-08-09 06:14:33 - SQL Server Tutorials


Prompt Examples

ChatGPT Prompt Examples

posted on 2023-06-21 22:37:19 - ChatGPT Tutorials


Use Cases

Chat GPT Key Use Cases

posted on 2023-06-21 21:03:17 - ChatGPT Tutorials


Prompt Frameworks

Prompt Frameworks

posted on 2023-06-21 19:33:06 - ChatGPT Tutorials