Advertisement

Latest Post

Friday, 16 September 2016

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








Government Jobs