Which SQL query is in the correct order to query the database in the FortiAnslyzer?

Question

Options

• ASELECT devid WHERE 'user'='USER1' FROM $log GROUP BY devid
• BFROM $log WHERE 'user'='USER1' SELECT devid GROUP BY devid
• CSELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid
• DSELECT devid FROM $log GROUP BY devid WHERE 'user'='USER1'

• A
  3% (1)
• B
  7% (2)
• C
  73% (22)
• D
  17% (5)

Explanation

The main clauses FortiAnalyzer reports use are as follows: Accordingly, following the SELECT keyword, the statement must be followed by one or more clauses in the order in which they appear in the table shown on this slide.

No community discussion yet for this question.