/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 vote100 views1 answer
2020 new year
SQL
0 vote105 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
2 votes107 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote55 views1 answer
Finish transaction sql
SQL
0 vote107 views1 answer
Postgresql array to rows
SQL
16 votes117 views2 answers
Sql vs nosql
SQL
3 votes93 views2 answers
Find string in stored procedure sql server
SQL
0 vote104 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote106 views1 answer
Drop-toys-table
SQL
3 votes87 views1 answer
Difference sql vs mysql
SQL