/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

2 votes158 views1 answer
Sql find missing values between two tables
SQL
1 vote212 views1 answer
Oracle drop temporary table
SQL
0 vote181 views1 answer
Order by in codeigniter query builder
SQL
0 vote172 views2 answers
SQL Server Standard
SQL
15 votes183 views2 answers
Select Options
SQL
0 vote128 views1 answer
Sql table to store status
SQL
19 votes174 views2 answers
Mysql tinyint max value
SQL
-2 votes205 views3 answers
How to fetch first 10 rows in sql
SQL
7 votes168 views2 answers
Get database size mysql
SQL
0 vote219 views1 answer
How to use sqlcommand
SQL