Difference between revisions of "Issue queries"

From SQLZOO
Jump to: navigation, search
(Created page with "<p>Here you are shown how to issue queries without using a table.</p> <p>This is done in different ways across different platforms but all of them will give a single row of in...")
 
 
Line 1: Line 1:
 
<p>Here you are shown how to issue queries without using a table.</p>
 
<p>Here you are shown how to issue queries without using a table.</p>
 
<p>This is done in different ways across different platforms but all of them will give a single row of information.</p>  
 
<p>This is done in different ways across different platforms but all of them will give a single row of information.</p>  
causes the response speed of the query to slow down.
 
 
<div class='ht'>
 
<div class='ht'>
 
<div class=params>schema:scott</div>
 
<div class=params>schema:scott</div>

Latest revision as of 08:56, 8 August 2012

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.

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