/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

1 vote112 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote111 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote113 views1 answer
How to save data in database in mysql node
SQL
-1 vote137 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote108 views1 answer
MySQL AND Operator
SQL
5 votes125 views1 answer
Oracle list functions
SQL
0 vote102 views1 answer
Lost connection to mysql
SQL
9 votes125 views4 answers
Oracle get table column names
SQL
6 votes114 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote101 views1 answer
Concat column value of same user in mysql
SQL