Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 2 3 4 5 < 6 > 7 8 9 10 11 12 .. 241 >> Next


String Function: INDEX........................................6-37

String Function: MINDEX.......................................6-42

String Function: TRIM ........................................6-43

String Function: VARGRAPHIC ..................................6-48

String Function: CHAR2HEXINT..................................6-50

xiv

Teradata RDBMS for UNIX SQL Reference
Table of Contents

String Function: UPPER...........................................6-51

Logical Expressions..............................................6-52

Comparison Operators.............................................6-53

CASE Blind Comparisons...........................................6-56

Japanese Character Site Comparison Operators.....................6-62

Logical Expressions: IN and NOT IN Operator......................6-65

Logical Expressions: IS NULL and IS NOT NULL Operator............6-68

Logical Expressions: EXISTS......................................6-70

Logical Expressions: LIKE Partial-String Operator................6-74

Logical Expressions: Japanese Character Site, LIKE Operator......6-81

Conditional Expressions..........................................6-85

CASE Expression..................................................6-88

Valued CASE Expression...........................................6-89

Searched CASE Expression.........................................6-91

CASE Abbreviation Expressions....................................6-94

NULLIF...........................................................6-95

COALESCE.........................................................6-96

Built-In Values .................................................6-97

DATE.............................................................6-98

TIME.............................................................6-99

USER............................................................6-100

NULL............................................................6-101

Indicator Variables.............................................6-102

Chapter 7

Queries: The SELECT Statement

About This Chapter..............................................7-1

SELECT..........................................................7-2

Simple SELECT Statement........................................7-10

WHERE Clause...................................................7-11

Subqueries in Search Conditions................................7-14

FROM Clause....................................................7-16

Derived Tables.................................................7-20

WITH Clause....................................................7-24

GROUP BY Clause................................................7-30

HAVING Clause..................................................7-32

ORDER BY Clause................................................7-34

DISTINCT and ALL Options.......................................7-41

Query Expressions (Set Operators)..............................7-43

UNION Operator.................................................7-50

INTERSECT Operator.............................................7-54

Teradata RDBMS for UNIX SQL Reference

xv
Table of Contents

EXCEPT (MINUS) Operator...........................................7-55

Chapter 8

Teradata SQL Syntax Guide

About This Chapter...................................8-1

ABORT................................................8-4

ALTER TABLE..........................................8-7

BEGIN/END LOGGING...................................8-29

BEGIN/ END TRANSACTION..............................8-38

CHECKPOINT..........................................8-42

COLLECT STATISTICS..................................8-44

COMMENT.............................................8-48

COMMIT..............................................8-51

CREATE DATABASE.....................................8-53

CREATE INDEX........................................8-59

CREATE MACRO........................................8-62

CREATE TABLE........................................8-69

CREATE USER.........................................8-95

CREATE VIEW........................................8-104

DATABASE...........................................8-116

DELETE.............................................8-117

DELETE DATABASE, DELETE USER.......................8-125

DROP DATABASE, DROP USER...........................8-127

DROP INDEX.........................................8-129

DROP MACRO, TABLE, or VIEW.........................8-131

DROP STATISTICS....................................8-133

ECHO...............................................8-136

EXECUTE............................................8-137

EXPLAIN Modifier...................................8-140

GIVE...............................................8-148

GRANT..............................................8-151
Previous << 1 .. 2 3 4 5 < 6 > 7 8 9 10 11 12 .. 241 >> Next