Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for Delphi 5 » SQL Reference » Naming Conventions |
SELECT * FROM "Customer Data"
SELECT * FROM "c:\sample\parts"
SELECT * FROM "parts.dat"
SELECT * FROM "\Sample Data\parts"
SELECT * FROM "\Memory\parts"
SELECT E."Emp Id" FROM employee E
SELECT weblog.[date] FROM weblog
SELECT * FROM customer WHERE Company='ABC Widgets'
UPDATE customer SET Notes='ABC Widgets'+ #13+#10+'Located in New York City'
Constant | Format |
Dates | The date format is yyyy-mm-dd where yyyy is the year (4 digits required), mm is the month (leading zero optional), and the day (leading zero optional). |
Times | The time format is hh:mm:ss.zzz am/pm where hh is the hour (leading zero optional), mm is the minutes (leading zero optional), ss is the seconds (leading zero optional), zzz is the milliseconds (leading zero optional), and the am/pm designation for times using the 12-hour clock. The seconds and milliseconds are optional when specifying a time, as is the am/pm designation. If the am/pm designation is omitted, the time is expected to be in 24-hour clock format. |
Timestamps (date/time) | The timestamp format is a combination of the date format and the time format with a space in-between the two formats. |
Numbers | All numbers are expected to use the period (.) as the decimal separator and no monetary symbols must be used. DBISAM's SQL does not support scientific notation in number constants currently. |
SELECT * FROM orders WHERE (saledate <= '1998-01-23')
SELECT * FROM transfers WHERE (paid = TRUE) AND NOT (incomplete = FALSE)
SELECT * FROM "c:\temp\customer.dat" LEFT OUTER JOIN "c:\temp\orders.dat" ON (customer.custno = orders.custno)
SELECT * FROM "customer.dat" LEFT OUTER JOIN "orders.dat" ON ("customer.dat".custno = "orders.dat".custno)
SELECT * FROM "customer" C LEFT OUTER JOIN "orders" O ON (C.custno = O.custno)
SELECT customer.company AS "Company Name", orders.orderno AS "Order #", sum(items.qty) AS "Total Qty" FROM customer LEFT OUTER JOIN orders ON customer.custno=orders.custno LEFT OUTER JOIN items ON orders.orderno=items.orderno WHERE customer.company LIKE '%Diver%' GROUP BY 1,2 ORDER BY 1
SELECT customer.company "Company Name", orders.orderno "Order #", sum(items.qty) "Total Qty" FROM customer LEFT OUTER JOIN orders ON customer.custno=orders.custno LEFT OUTER JOIN items ON orders.orderno=items.orderno WHERE customer.company LIKE '%Diver%' GROUP BY 1,2 ORDER BY 1
/* This is a comment */ SELECT SUBSTRING(company FROM 1 FOR 4) AS abbrev FROM customer
SELECT company FROM customer /* WHERE (state = 'TX') */ ORDER BY company
ABS ACOS ADD ALL ALLTRIM ALTER AND AS ASC ASCENDING ASIN AT ATAN ATAN2 AUTOINC AVG BETWEEN BINARY BIT BLOB BLOCK BOOL BOOLEAN BOTH BY BYTES CAST CEIL CEILING CHAR CHARACTER CHARCASE CHARS COALESCE COLUMN COLUMNS COMMIT COMPRESS CONCAT CONSTRAINT COS COT COUNT CREATE CURRENT_DATE CURRENT_GUID CURRENT_TIME CURRENT_TIMESTAMP DAY DAYOFWEEK DAYOFYEAR DAYSFROMMSECS DECIMAL DEFAULT DEGREES DELETE DELIMITER DESC DESCENDING DESCRIPTION DISTINCT DROP DUPBYTE ELSE EMPTY ENCRYPTED ESCAPE EXCEPT EXISTS EXP EXPORT EXTRACT FALSE FLOAT FLOOR FLUSH FOR FORCEINDEXREBUILD FROM FULL GRAPHIC GROUP GUID HAVING HEADERS HOUR HOURSFROMMSECS IDENT_CURRENT IDENTITY IF IFNULL IMPORT IN INCLUDE INDEX INNER INSERT INT INTEGER INTERSECT INTERVAL INTO IS JOIN KEY LARGEINT LAST LASTAUTOINC LCASE LEADING LEFT LENGTH LIKE LOCALE LOG LOG10 LONGVARBINARY LONGVARCHAR LOWER LTRIM MAJOR MAX MAXIMUM MEMO MIN MINIMUM MINOR MINSFROMMSECS MINUTE MOD MONEY MONTH MSECOND MSECSFROMMSECS NOBACKUP NOCASE NOCHANGE NOJOINOPTIMIZE NONE NOT NULL NUMERIC OCCURS ON OPTIMIZE OR ORDER OUTER PAGE PI POS POSITION POWER PRIMARY RADIANS RAND RANGE REDEFINE RENAME REPAIR REPEAT REPLACE RIGHT ROLLBACK ROUND RTRIM RUNSUM SECOND SECSFROMMSECS SELECT SET SIGN SIN SIZE SMALLINT SPACE SQRT START STDDEV STOP SUBSTRING SUM TABLE TAN TEXT TEXTOCCURS TEXTSEARCH THEN TIME TIMESTAMP TO TOP TRAILBYTE TRAILING TRANSACTION TRIM TRUE TRUNC TRUNCATE UCASE UNION UNIQUE UPDATE UPGRADE UPPER USER VALUES VARBINARY VARBYTES VARCHAR VERIFY VERSION WEEK WHERE WITH WORD WORDS WORK YEAR YEARSFROMMSECS
| + - * / <> < > . ; , = <= >= ( ) [ ] #
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |