ALL Sql Keyword

ALL

This keyword is used with the asterisk "*" in a SELECT statement. By this keyword you can select all fields from a table.

Syntax: The basic syntax of All is below

 

 SELECT ALL * FROM table_nam;

Example:

USE SQLCLR

GO

SELECT ALL * FROM Employee

GO

Id	Name	Age	Address
1	Alok Kumar Singh	30	IN
2	Tomas Paul	45	NZ
3	Cristomfer Dee	85	AU
4	Niel Macengi	55	US