Issue queries

From SQLZOO
Revision as of 08:52, 8 August 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Here you are shown how to issue queries without using a table.

This is done in different ways across different platforms but all of them will give a single row of information.

causes the response speed of the query to slow down.

schema:scott
 
 

Only certain functions can be used without a table and these functions are called static functions.

Static functions can allow a user to obtain the current username, current date, current timestamp and also the version of the database being used.

SELECT CURRENT_USER, CURRENT_DATE
SELECT USER, CURRENT_DATE FROM dual
SELECT SYSTEM_USER, GETDATE()
SELECT ENVIRON('username'), DATE()
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense