SQL in a Nutshell (In a Nutshell (OReilly))

     
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y]

naming conventions

NANVL function (Oracle)

NATIONAL CHAR datatype

        Oracle

        platform comparison

        SQL Server

NATIONAL CHAR VARYING datatype

        Oracle

        platform comparison

        SQL Server

NATIONAL CHARACTER datatype

        Oracle

        platform comparison

        SQL Server

NATIONAL CHARACTER VARYING datatype

        MySQL

        Oracle

        platform comparison

        SQL Server

NATIONAL TEXT datatype

        platform comparison

        SQL Server

NATURAL [INNER {LEFT RIGHT}[ OUTER] ] JOIN

NCHAR datatype

        MySQL

        Oracle

        platform comparison

        SQL Server

NCHAR function

        Oracle

        SQL Server

NCHAR VARYING datatype

        Oracle

        platform comparison

NCHAR( ) datatype

        SQL Server 2nd

        Sybase adaptive server

NCLOB datatype

        Oracle

        platform comparison

nested parentheses and operator precedence

nested tables

        in FROM clause

        Oracle

        subqueries

NETMASK function (PostgreSQL)

NETWORK function (PostgreSQL)

NEW_TIME function (Oracle)

NEWID( ) function

        SQL Server

NEXT_DAY function (Oracle)

NLS_CHARSET_DECL_LEN function (Oracle)

NLS_CHARSET_ID function (Oracle)

NLS_CHARSET_NAME function (Oracle)

NLS_INITCAP function (Oracle)

NLS_LOWER function (Oracle)

NLS_UPPER function (Oracle)

NLSSORT function (Oracle)

nondeterministic functions

not equal to (!=) operator 2nd 3rd

not greater than (!>) operator

not less than (!<) operator

NOT operator

NOW( ) function (MySQL)

NPOINTS function (PostgreSQL)

NTEXT datatype

        platform comparison

        SQL Server 2nd

NTILE function (Oracle)

NULL values

NULLIF function

        DB2

        MySQL

        Oracle

        PostgreSQL

        SQL Server

NUM datatype

        DB2

NUMBER datatype

        Oracle

        platform comparison

NUMERIC datatype

        DB2

        MySQL

        Oracle

        platform comparison

        PostgreSQL 2nd

        SQL Server 2nd

numeric datatype and unary operators

numeric functions

        enhanced

NUMTODSINTERVAL function (Oracle)

NUMTOYMINTERVAL function (Oracle)

NVARACHAR( ) datatype (Sybase Adaptive Server)

NVARCHAR datatype

        MySQL

        platform comparison

        SQL Server

NVARCHAR2 datatype

        Oracle

NVARCHAR2( ) datatype

        platform comparison

NVL function (Oracle)

NVL2 function (Oracle)

 

Категории