SELECT ALL SQL Server Syntax Example: SELECT ALL argument T-SQL Example

Get 5 Hours of FREE PREMIUM Videos:

LearnVisualStudio.NET Free Preview

LearnVisualStudio Premium Videos

dotNetVideos Premium Video Catalog

SELECT ALL SQL Server Syntax Example: SELECT ALL argument T-SQL Example

Purpose: – Illustrates the SQL Server syntax for the SELECT all argument.

Syntax: SELECT [ ALL | DISTINCT ]
[TOP ( expression ) [PERCENT] [ WITH TIES ] ]
select_list
[ INTO new_table ]
[ FROM { table_source } [ ,...n ] ]
[ WHERE search_condition ]
[ GROUP BY ]
[ HAVING search_condition ] – ALL indicates that duplicates are included in search results

 T-SQL | 
 copy code |
?
 
-- SELECT ALL 
-- PURPOSE: ALL indicates that duplicates are to be included - ALL is the default 
-- and DISTINCT is the other option  
-- SYNTAX: SELECT [ ALL | DISTINCT ] 
--			[TOP ( expression ) [PERCENT] [ WITH TIES ] ] 
--			 select_list 
--			[ INTO new_table ] 
--			[ FROM { table_source } [ ,...n ] ] 
--			[ WHERE search_condition ] 
--			[  GROUP BY  ] 
--			[ HAVING search_condition ] 
 
 
CREATE TABLE people(
     ID          int,
     name        varchar (20),
     height      int )
 GO
 
 
 
 
 INSERT INTO people (ID, name, height) VALUES (1,  'Paul', 72)
 GO
 
 INSERT INTO people (ID, name, height) VALUES (2,  'John', 69)
 GO
 
 INSERT INTO people (ID, name, height) VALUES (3,  'Steve', 75)
 GO
 
 INSERT INTO people (ID, name, height) VALUES (4,  'Steve', 65)
 GO
 
-- ALL includes duplicates
 SELECT ALL name FROM people;
 GO
 
-- DISTINCT excludes duplicates
 SELECT DISTINCT name FROM people;
 GO
 
 
 drop table people;
 
 GO
 
 
 

Sample Output for SELECT ALL Example

Related posts:

1. Subquery ALL SQL Server Example: Subquery ALL modifier Example Subquery ALL SQL Server Example: Subquery ALL modifier Example...
2. SQL Server 2005:(10 Hours) Backup SQL Server 2005, SQL Server Insert, SQL Server Training, SQL Server Profiler, Download SQL Server 2005, SQL Server Script, SQL Server Tutorial 10 Free One-Hour Videos From Microsoft Expert, Bryan Von Axelson....
3. SQL Server / T-SQL Examples Here is a library of SQL Server / T-SQL Examples....
4. SQL Server 2005 Express Tutorial: (13 Videos) Database mirroring, backup sql server 2005, sql server 2005 replication, sql server standard edition, download sql server 2005, compare sql server, sql server instance Excellent SQL Server 2005 Express series of 13 free videos...
5. C# Select Statement Source Code Example Source Code example shows how to use Sql Select in...

Related posts brought to you by Yet Another Related Posts Plugin.