2 type Query
1. SOQL : Salesforce Object Query Language
2, SOSL: Salesforce Object Search language
SOQL:
Return Type: List<sObject>
Limit: 50000
DML Perform (Insert, Update,Delete Upsert)
1. SELECT Id,Name FROM Account : Specific field
2. SELECT Fields(ALL) FROM Account LIMIT 200 : all fields from sObject
3. SELECT Id,Name FROM Account LIMIT 5
4. SELECT Id,Name FROM Account WHERE Name = 'Test'
5. SELECT Id,Name,createdDate FROM Account WHERE Name = 'Test' ORDER BY CreatedDate
6. SELECT Id,Name,createdDate FROM Account WHERE Name = 'Test' ORDER BY CreatedDate
ASC
7. SELECT Id,Name,createdDate FROM Account WHERE Name = 'Test' ORDER BY CreatedDate
ASC LIMIT 1
8. SELECT Id,Name,createdDate FROM Account WHERE Name = 'Test' ORDER BY CreatedDate
DESC
9. SELECT Id,Name,createdDate FROM Account WHERE Name = 'Test' ORDER BY CreatedDate
DESC LIMIT 1
10. SELECT Id,FirstName,createdDate FROM Contact ORDER BY FirstName NULLS First
11. SELECT Id,FirstName,createdDate FROM Contact ORDER BY FirstName NULLS Last
Custom Object Query:
1. SELECT Id, createdDate FROM Bank__c
Parent to child query
1. SELECT Id,Name,(SELECT Id,FirstName,LastName FROM Contacts) FROM Account
Child to parent Query:
1. SELECT Id,Account.Name,Account.Phone FROM Contact
Parent 1
Child 1
Child 2
SELECT Id,Account.Name,Account.Phone FROM Contact
SELECT : SOQL Keyword
Id,Name: sObject Fields
FROM: SOQL Keyword
ACcount: sObject
SOSL:
Return Type: List<List<sObject>>
Limit more than 50K to 5Million
DML Not allowed
FIND Id,Name FROM Account
array []
List<>
