/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 vote129 views1 answer
Mysql limit order by
SQL
0 vote123 views1 answer
How to get specific salary in sql
SQL
0 vote114 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote138 views1 answer
Oracle running queries
SQL
2 votes116 views2 answers
Mysql get time from datetime
SQL
0 vote130 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote118 views1 answer
Nvl2 syntax
SQL
2 votes126 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote118 views1 answer
Mysql milliseconds
SQL
28 votes117 views6 answers
Mysql change user password
SQL