To return only few columns from a database table, we write column names followed by the SELECT statement.
In general, columns are written separated by comma however if the column name contains blank space, we warp them with square bracket “[column name].
SELECT FirstName, LastName, Age FROM PersonalDetails SELECT [FirstName], [LastName], [Age] FROM PersonalDetails
Above, both query would return the same result. In 1st case directly field names are written and in 2nd case field names are wrapped with “[ ]”.Views: 2027 | Post Order: 43