/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 votes313 views1 answer
Mysql now format
SQL
5 votes324 views2 answers
Oracle find all tables with column name
SQL
0 vote327 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
8 votes336 views1 answer
See all users mysql
SQL
3 votes336 views6 answers
Jwt laravel
SQL
0 vote322 views2 answers
Mysql set foreign_key_checks=0
SQL
6 votes312 views3 answers
Commit in sql
SQL
0 vote303 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote320 views1 answer
Name of today sql
SQL
1 vote320 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL