/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

22 votes284 views3 answers
How to join three tables in sql using joins
SQL
1 vote257 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote278 views1 answer
Cahnge column name apex oracle
SQL
1 vote264 views1 answer
Mysql list bigger table
SQL
4 votes253 views3 answers
Rename table column postgresql
SQL
0 vote250 views1 answer
Luu ckeditor vao mysql
SQL
0 vote265 views1 answer
How to alter length character varying postgres
SQL
1 vote255 views1 answer
Mysql view current queries
SQL
0 vote261 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes258 views1 answer
Oracle current date without time
SQL