Online Course Support

The statement DESCRIBE workforce; has the following result: name type comment name string occupation string salary int Which is the best statement to get a list of the occupations used in the table?

Question 9
The statement DESCRIBE workforce; has the following result:

name type comment
name string
occupation string
salary int
Which is the best statement to get a list of the occupations used in the table?

1 point

  • SELECT salary FROM workforce;
  • SELECT DISTINCT salary FROM workforce;
  • SELECT occupation, salary DISTINCT FROM workforce;
  • SELECT DISTINCT occupation, salary FROM workforce;
  • SELECT salary DISTINCT FROM workforce;
  • SELECT DISTINCT occupation FROM workforce;
  • SELECT occupation FROM workforce;
  • SELECT occupation DISTINCT FROM workforce;

Similar Posts