|
|
|
|
|
|
|
The mathematical SQL functions that can be used on the queries written in SQL code are as follows...
|
|
|
|
|
|
|
A query (typed in SQL code) can operate on different databases...
|
|
|
|
|
|
|
WINDEV allows you to easily run queries in SQL code...
|
|
|
|
|
|
|
The following SQL functions can be used on the queries written in SQL code (classified by theme)...
|
|
|
|
|
|
|
To select records coming from several data files, joins must be used in the SQL query...
|
|
|
|
|
|
|
The ORDER BY clause is used to sort the records selected by an SQL query...
|
|
|
|
|
|
|
To specify the selection conditions in an SQL query, you can use...
|
|
|
|
|
|
|
SQL allows performing set operations on groups of files...
|
|
|
|
|
|
|
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...
|
|
|
|
|
|
|
A sub-query is a query whose result is used by another query...
|
|
|
|
|
|
|
Starting with version 21, you can manage transactions in SQL code...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|