• Home
  • Tutorials
  • Interviews
  • Info Seed
  • Forums
  • Projects
  • Links
  • Contact Us
SQL Server
HOW TO START...??
CREATING DATABASE
CREATING TABLE
INSERTION
SELECTION
USING DISTINCT
WHERE CLAUSE
AS IN SQL
OPERATORS
ARITHMETIC OPERATOR
RATIONAL OPERATOR
LOGICAL OPERATOR
DELETE
UPDATE
LIKE OPERATOR AND WILDCARDS
BETWEEN OPERATORS
IN CLAUSE
ORDER BY
JOINS
UNION
INTERSECT
ALL/ANY
SQL CONSTRAINT
INDEX
DROP
Alter
FUNCTIONS
GROUP BY
HAVING CLAUSE
VIEWS

 

Operators

  • There are 3 categories of operators:
  • Arithmetic operators  (+,-,*,/)
  • Rational operators  (>,>=,<,<=,!=,=)
  • Logical operators  (and,or,not)

           Syntax

Select column_name(s) from table_name where column_name operator value

    • Lets discuss all these operators one by one
    • To explain these operators I have prepared a new table called ‘Exr_exam’

     

     

     

     

     

     

     

     

     

    previous next
 
Lorem: Lorum | Ipsum | Dolar | Sic Amet | Consectetur | Lorum | Ipsum | Dolar | Sic Amet | Consectetur