Which SQL query is in the correct order to query the database in the FortiAnalyzer?
Select an option, then click Submit answer.
Reference / correct answer:
SELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid
Most accepted answer: C. SELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid
Community votes: C=1
Selected Answer: C The order is : SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET. FortiAnalyzer_Analyst_7.2_Study_Guide page 11 upvoted 1 times
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. upvoted 2 times