Which SQL query is in the correct order to query the database in the FortiAnalyzer?
Which SQL query is in the correct order to query the database in the FortiAnalyzer?
The correct order for an SQL query to query a database is SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET. Option C follows this sequence properly: it starts with SELECT devid, specifies the table with FROM $log, filters the results with WHERE 'user'='USER1', and then groups the results with GROUP BY devid.
C is correct. There is a mandatory sequence of SQL commands (if they are used, after SELECT and FROM, the rest are optional) Page 141 of 7.2 Study Guide. The order is : SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET.
The order is : SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET. FortiAnalyzer_Analyst_7.2_Study_Guide page 11