According to Sams Teach Yourself SQL, if you just use SELECT without FROM, you can do the following:
-
Get information such as current date
SELECT CURDATE(0) ; == (should return current date) -
Do a calculation
SELECT 4*5 ; ==(should return value of 20)
3.See if functions are working properly
SELECT RTRIM("abc "); ==(should return string abc).
However, in LibreOffice 5.4 BASE, when I use select alone, I get “Syntax error in SQL statement”.
Any thoughts? Thanks!