SELECT FIELDS(ALL) FROM CASE LIMIT 10
The above SOQL query will display all the fields of the Account Object.
SELECT FIELDS(STANDARD) FROM Account LIMIT 10
SELECT FIELDS(CUSTOM) FROM Account LIMIT 10