/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 vote156 views1 answer
Opensuse stop MySQL
SQL
1 vote223 views1 answer
Add time to date sql
SQL
0 vote172 views1 answer
Execute sql stored procedure in powershell
SQL
37 votes179 views3 answers
Duplicate records in sql
SQL
1 vote173 views3 answers
How to get date in sql
SQL
0 vote166 views1 answer
Mysql remove tabs from string
SQL
0 vote193 views1 answer
Like date sql server not working
SQL
1 vote146 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
1 vote169 views2 answers
Install mysqldump ubuntu
SQL
0 vote140 views1 answer
Import csv to mysql
SQL