Pages

▼
Showing posts with label SQL Reference Guide. Show all posts
Showing posts with label SQL Reference Guide. Show all posts

SQL basics- complete reference guide - part8 SQL System Commands

›
Part8: SQL System Commands Reference guide TOPIC TEXT SYNTAX Example ARRAY_GET Returns one element of an array. ARRAY_GET(arrayExpres...

SQL basics- complete reference guide - part7 - Date Time Functions

›
Part7: SQL Date Time Functions Reference TOPIC TEXT SYNTAX Example CURRENT_DATE Returns the current date. { CURRENT_DATE [ () ] | CUR...

SQL basics- complete reference guide - part6 - String functions

›
Part6: SQL String Functions Complete Reference TOPIC TEXT SYNTAX Example ASCII Returns the ASCII value of the first character in the ...

SQL basics- complete reference guide - part5 - Mathematical Functions

›
Part5: Mathematical Functions in SQL- Complete Reference Function Description SYNTAX Example ABS ABS ( { int | long | decimal | doubl...

SQL basics- complete reference guide - part4 - Aggregate Functions in SQL

›
Part4: Aggregate Functions in SQL- complete reference sheet Command/Function Description SYNTAX Example AVG The average (mean) value....

SQL basics- complete reference guide - part3 - Data Types in SQL

›
Part3: SQL Data Types Reference TOPIC TEXT SYNTAX Example INT Type Possible values: -2147483648 to 2147483647. INT | INTEGER | MEDIUM...

SQL basics- complete reference guide - part2 - DDL

›
Part2: DDL -Data Definition Language Reference Command Description SYNTAX Example ALTER INDEX RENAME Renames an index. ALTER INDEX in...

SQL basics- complete reference guide - part1 - DML

›
Part1: DML-Data Manipulation Language Command Description SYNTAX Example SELECT Selects data from a table or multiple tables. SELECT ...