/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 vote228 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote231 views1 answer
VSCode SQL Server Connection error
SQL
1 vote260 views1 answer
Find size of all DB's postgres
SQL
13 votes236 views1 answer
Views in sql
SQL
0 vote216 views1 answer
Copied text from internet not inserting in mysql
SQL
3 votes256 views2 answers
Oracle sql first day of month
SQL
1 vote243 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote277 views1 answer
How to use sqlcommand
SQL
1 vote257 views1 answer
Primary key with prefix sql
SQL
1 vote234 views1 answer
Launch sql script from docker in mysql
SQL