Question · SQL and MySQL course · Module 2: Querying data (SELECT)

The asterisk vs chosen columns

How does the result of "SELECT * FROM ksiazki;" differ from the result of "SELECT tytul, cena FROM ksiazki;"?

Answer options

  • It has more rows and the same number of columns
  • It has fewer rows, because the asterisk skips empty fields
  • No difference - both queries return the same result
  • It has the same number of rows, but more columns - every field of the shelf
Show the answer

Correct answer:

  • It has the same number of rows, but more columns - every field of the shelf