/SQL/How to select all fieldsin a soql query

How to select all fieldsin a soql query

// This is the object for which we required data.
Map<String, Schema.SObjectField> fieldMap = Opportunity.sObjectType.getDescribe().fields.getMap();
  
// Get all of the fields on the object
Set<String> fieldNames = fieldMap.keySet();
 
// Build a Dynamic Query String.
List<Opportunity> opps = Database.query('select ' + string.join(fieldNames, ',') + ' from Opportunity');

Source: brcline.com

Similar codes

8 votes306 views1 answer
Sql remove characters from string right
SQL
0 vote346 views1 answer
Error code 1241 mysql
SQL
7 votes335 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote343 views1 answer
Arithmetic expression in sql
SQL
1 vote318 views1 answer
Sqlite3 read only
SQL
5 votes313 views1 answer
Update sql user password
SQL
7 votes310 views1 answer
Append column sql
SQL
0 vote354 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote358 views1 answer
How to find sql server installation folder
SQL
0 vote330 views1 answer
Difference between 2 query results sql server
SQL