/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 vote185 views1 answer
Default column value in sql same as other column
SQL
0 vote204 views1 answer
How to display value of variable in mysql
SQL
0 vote210 views1 answer
Show all sequences postgres
SQL
3 votes192 views3 answers
Stop mysql ubuntu
SQL
9 votes213 views3 answers
Where clause sql
SQL
18 votes192 views2 answers
Sql inner join
SQL
0 vote151 views1 answer
Alter session set nls_language french
SQL
0 vote205 views1 answer
Insert data from stored procedure into table
SQL
0 vote197 views1 answer
Interview experience as a call?
SQL
0 vote195 views1 answer
How to install postgresql on wsl
SQL