SQL Select Statement

SQL Select Statement

Hi friends, in this post we will learn about SQL Select Statement or you can say Select Query to get data from SQL server tables. SQL Select Statement are used to fetch data rows from table. In SQL Select Query we can also add conditions to get conditional data only.

Earlier we had discussed about SQL Insert Statement, Drop Table SQL Server, Rename Table in SQL Server, Create Table SQL Server, Schema In SQL Server, SQL Server Operators, Data Type in SQL Server and Drop-Delete SQL Server Database Using Management Studio or Query.

SQL Select Query:

----USE DATABASE----
USE Hightechnology
GO

----SELECT ALL DATA FROM TABLE----
SELECT * FROM [dbo].[STUDENT_INFORMATION]

----SELECT TOP 1 RECORD FROM TABLE----
SELECT TOP 1 * FROM [dbo].[STUDENT_INFORMATION]

----SELECT RECORD BASED ON CONDITIONS FROM TABLE----
SELECT * FROM [dbo].[STUDENT_INFORMATION] WHERE ID=1

----SELECT PARTICULAR COLUMNS FROM TABLE----
SELECT ID,NAME,PERMADDRESS FROM [dbo].[STUDENT_INFORMATION]

SQL Select through Management Studio:

1. Open SQL Server Management Studio, and connect to SQL Server.

2. Expand Database name > Right click on table, from which you want to Select data and click on Select Top 1000 Rows.