BETWEEN AND – SQL Server Syntax Example: BETWEEN AND – T-SQL Example

Get 5 Hours of FREE PREMIUM Videos:

LearnVisualStudio.NET Free Preview

LearnVisualStudio Premium Videos

dotNetVideos Premium Video Catalog

BETWEEN AND – SQL Server Syntax Example: BETWEEN AND – T-SQL Example

Purpose: – Illustrates the SQL Server syntax for the BETWEEN AND .

Syntax: SELECT [ ALL | DISTINCT ]
[TOP ( expression ) [PERCENT] [ WITH TIES ] ]
select_list
[ INTO new_table ]
[ FROM { table_source } [ ,...n ] ]
[ WHERE column1 BETWEEN lowerbound AND upperbound ]
[ GROUP BY ]
[ HAVING search_condition ]
– AS allows you change column name that is displayed and also allows you to group several columns into one

 T-SQL | 
 copy code |
?
 
-- BETWEEN AND 
-- PURPOSE: BETWEEN sets lower and upper bounds of selected values
--          you to group several columns into one
-- SYNTAX: SELECT [ ALL | DISTINCT ] 
--			[TOP ( expression ) [PERCENT] [ WITH TIES ] ] 
--			< select_list > 
--			[ INTO new_table ] 
--			[ FROM { <table_source> } [ ,...n ] ] 
--			[ WHERE column1 BETWEEN lowerbound AND upperbound ] 
--			[ <group BY> ] 
--			[ HAVING < search_condition > ] 
 
 
CREATE TABLE people(
     ID          int,
     firstname   varchar (20),
     lastname    varchar (20),
     height      int )
 GO
 
 
 
 
 INSERT INTO people (ID, firstname, lastname, height) 
 VALUES (1,  'Paul', 'Revere', 72)
 GO
 
 INSERT INTO people (ID, firstname, lastname, height) 
 VALUES (2,  'John', 'Lennon', 69)
 GO
 
 INSERT INTO people (ID, firstname, lastname, height)
 VALUES (3,  'Steve', 'McQueen', 75)
 GO
 
 INSERT INTO people (ID, firstname, lastname, height) 
 VALUES (4,  'George', 'Washington', 65)
 GO
 
--Show entire table
 SELECT * FROM people
 ORDER BY height;
 GO
 
--BETWEEN set lower and upper bounds of selected values
 SELECT firstname + ' ' + lastname AS [Full Name], height as 'Height Inches'
  FROM people
  WHERE height BETWEEN 69 AND 75
  ORDER BY height; 
 GO
 
 
 drop table people;
 
 GO
 
 
 
</group></table_source>

Sample Output for BETWEEN AND Example

Related posts:

1. Column AS Alias SQL Server Syntax Example: Column AS T-SQL Example SELECT AS SQL Server Syntax Example: SELECT AS T-SQL Example...
2. SELECT ALL SQL Server Syntax Example: SELECT ALL argument T-SQL Example SELECT ALL SQL Server Example: SELECT ALL argument T-SQL Example...
3. SELECT AND SQL Server Syntax Example: SELECT AND logical operator T-SQL Example SELECT AND SQL Server Syntax Example: SELECT AND logical operator...
4. Subquery ALL SQL Server Example: Subquery ALL modifier Example Subquery ALL SQL Server Example: Subquery ALL modifier Example...
5. VB.NET Sql Parameters Source Code – Insert Statement Source code example that illustrates using SQL parameters with insert...

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