/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

1 vote295 views1 answer
Postgresql not in
SQL
1 vote263 views1 answer
Varchar plsql
SQL
0 vote319 views1 answer
Look at running processes redshift
SQL
0 vote271 views1 answer
Get last updated row sql server
SQL
0 vote284 views1 answer
Mysql get only the field names in a table
SQL
0 vote319 views1 answer
For row in sql database python loop
SQL
1 vote256 views1 answer
Mysqli connect
SQL
3 votes300 views1 answer
Postgres select max value
SQL
4 votes277 views1 answer
Mysql timestamp in laravel migration
SQL
1 vote293 views2 answers
Oracle difference between two dates in seconds
SQL