The SELECT statement in SQL is used to retrieve data from a database. Mostly used to retrieve all data in a table and data from desired table columns (fields).
In the above syntax, you are selecting data from exact columns or fields indicated as column1, column2, column3 and so on.
To select all fields in your table, use below syntax.
SELECT All Syntax
You can practice with the SELECT syntax examples above based on the database you have access.
Subscribe and improve your SQL skills on our SQL journey from beginner to advanced skills.