/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 vote144 views1 answer
Select row from mysql where date more than 30 days
SQL
1 vote139 views1 answer
Apex ORA-20999
SQL
2 votes143 views3 answers
Current month mysql query
SQL
13 votes132 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
25 votes183 views5 answers
Mysql replace text
SQL
13 votes291 views4 answers
Sql joining 3 tables
SQL
0 vote135 views1 answer
Csv to sqlite python
SQL
0 vote149 views2 answers
How to generate a unique random number in mysql
SQL
0 vote149 views1 answer
Group by join columns per table
SQL
0 vote148 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL