/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

0 vote232 views1 answer
Mysql select top 2
SQL
0 vote297 views2 answers
Suse stop MySQL
SQL
0 vote304 views1 answer
Sql pivot table
SQL
0 vote297 views1 answer
Sql update subtract value
SQL
0 vote285 views1 answer
Psql datestyle
SQL
0 vote309 views1 answer
Updating database in sql
SQL
16 votes295 views1 answer
Mysql smallint range
SQL
0 vote310 views2 answers
Unique key
SQL
0 vote289 views1 answer
Sql server beginning of month
SQL
11 votes297 views1 answer
Oracle insert into where
SQL