SQL Where Keyword, SQL Tutorial, Global Guide Line Technology.
Bookmark Bookmark: SQL Where Keyword, SQL Tutorial Forum | Blog |

      Home                    

Basic SQL Guide.           
SQL Introduction.               
 What is Table?                  
 SQL Create Table.            
 SQL Insert Statement.      
 SQL Select Keyword.        
 SQL Order by clause.        
 SQL Count Statement.      
 SQL Group By Clause.      
 SQL Having Clause.          
 SQL Alias Tables.             
 SQL Join Tables.              
 SQL Outer Join.               
 SQL Update Statement.   
 SQL Delete Statement.    
 SQL Distinct Keyword.      
 SQL Where Keyword.
 SQL And Or Keyword.      
 SQL In Keyword.              
 SQL Between Keyword.   
 SQL Like Keyword.          
 SQL Functions.                
 SQL Concatenate.           
 SQL Substrings.               
 SQL Trim Function.         
 SQL Constraints.              
 SQL Primary Key.            
 SQL Foreign Key.            
 SQL Create Views.           
 SQL Create Index.           
 SQL Alter Table.             
 SQL Drop Table.             
 SQL Truncate Table.      
 SQL Summary.                

SQL Tutorial >> SQL Where Keyword.


     Back             Next     



Next in SQL Tutorial we might want to conditionally select the data from a table. For example, we may want to only retrieve Salary more then 1000$ from the Employees_Salary table. To do this, we use the WHERE keyword. The syntax for SQL Where keyword is as follows:

Syntax for SQL Where Keyword

SELECT "column_name"
FROM "table_name"
WHERE "condition"

For example, to select all Employees name who have Salary amount more then 1000$ from the table Employees_Salary
Employees_Salary table is as under

Table of Employees_Salary

FirstName Month Salary
Austin January 1000$
Creston January 1000$
Kate January 1200$
Angela January 1000$
Bobbi January 1200$
Cute January 1300$

Example of SQL Where Keyword

SELECT FirstName, Month, Salary
FROM Employees_Salary
WHERE Salary > 10000

Result of SQL Where Keyword Example

FirstName Month Salary
Kate January 1200$
Bobbi January 1200$
Cute January 1300$
 

     Back             Next     
 

[ About ] [ Contact ] [ Home ]
[ Links ] [ Site Map ] [ Services ] [ Privacy ]

Copyright 2005 -  2018 www.globalguideline.com All rights reserved. (Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher) 168 visitors are online now