What will be the result of the query SELECT name?

The query SELECT name without specifying a table or other mandatory SQL syntax elements is incomplete and will cause an error in most DBMSs.

For correct execution, you need to specify a table, for example:

SELECT name FROM users;

If, in the context of Java, it refers to calling a method or variable name, then without additional context, it is impossible to determine the result.

Thus, simply SELECT name will not return any result and will lead to an error.