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