Which is the wildcard symbol for selecting all the fields in a table?
-
@
-
#
-
^
-
*
-
<
The asterisk (*) is the standard SQL wildcard character used in SELECT statements to retrieve all columns from a table. It saves listing individual field names when you need complete row data.
In SQL, the asterisk (*) is the wildcard that selects all columns/fields from a table, e.g. SELECT * FROM table_name. It's shorthand so you don't have to list every column name explicitly. The other symbols have unrelated or no meaning in this context: @ is typically used for variables or annotations in some languages, # can denote temp tables (in T-SQL) or comments, ^ is a bitwise/exponent operator, and < is a comparison operator. None of these select all fields, making * the only correct answer.