The symbol Asterisk (*) in a select query retrieves all data from the table.
What does asterisk (*) mean in SQL?
The asterisk or star symbol ( * ) means all columns. The semi-colon ( ; ) terminates the statement like a period in sentence or question mark in a question.
What does an asterisk (*) indicate?
An asterisk is a star-shaped symbol (*) that has a few uses in writing. It is most commonly used to signal a footnote, but it is sometimes also used to clarify a statement or to censor inappropriate language.