|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files...... |
|
|
|
|
|
|
|
| This help page explains how to create a count query with the query editor.... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items...... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...... |
|
|
|
|
|
|
|
| In some cases, it may be useful to run the same query multiple times while modifying one or more parameters...... |
|
|
|
|
|
|
|
| This help page explains how to create a query with a calculation formula with the query editor.... |
|
|
|
|
|
|
|
| In some cases, it may be useful to execute the same stored procedure multiple times by changing one or more parameters...... |
|
|
|
|
|
|
|
| In some cases, it may be useful to execute the same stored procedure multiple times by changing one or more parameters ...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| In SQL language, an external join is used to exclude or include file records with or without correspondences in the linked files...... |
|
|
|
|
|
|
|
| This help page explains how to create a sort query with the query editor.... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file...... |
|
|
|
|
|
|
|
| The queries with parameters allow the user to easily select records according to his own requirements...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|