Menu Bar

Home
Introduction to HTML Tables Elements and Attributes Lists Google Home Page Registration Form Forms_1 Forms_2
Introduction to CSS Three types of css Tables Forms(id,class,psuedo class) Backgrounds Periodic table Border in a table Margins and Padding Height,Width,Overflow
Introduction Basic Script Data types and Operators String methods and Arrays Functions and Objects Events Dialog boxes Conditions Loops Error Handling External JS Simple Calculator
Introduction SQL Installation and User creation SQL:Database and Table Creation SQL:Alter Constraints Select,Insert Delete Operators Functions Joins, Union, GroupBy Missing Items User Defined Functions Views Backup and Restore Company DB, Table and records Queries on Company DB Computer Business DB and Queries
Introduction Variables, Datatypes & Operators Conditional & Looping Statements Functions Pointers & Recursion Array & Files Patterns
Introduction Problems in C++
Configuration SQL server connection Introduction to PHP
Introduction VB.NET VB.NET Compilation & Run VB.NET Problems No link
Design Principles Stone Profit support page MasterLegacy MasterDev Work with Live System

Operators

Chapter 11:
SQL Operators
  1. Arithmetic Operators
  2. Comparison
  3. Logical

Arithmetic Operators:




Comparison Operators:

Equals:



Greater-than:



Less-than:



Greater-than or equal:



Less-than or equal:



Not Equal:


Logical Operators:
AND: Performs a logical AND operation. The expression evaluates to TRUE if all conditions are TRUE.
OR: Performs a logical OR operation. The expression evaluates to TRUE if at least one condition is TRUE.
ALL: Compares a scalar value with a single-column set of values.
ANY: Compare a scalar value with a single-column set of values. ANY returns TRUE when the comparison specified is TRUE for any pair, otherwise returns FALSE.
SOME: Compare a scalar value with a single-column set of values. SOME returns TRUE when the comparison specified is TRUE for any pair, otherwise returns FALSE.
EXISTS: Specifies a sub-query to test for the existence of rows. It returns data when a specified record exist in the table which is given in sub query of where condition.



Subscribe to: Posts (Atom)