In DetailThis practical guide will tell you everything you need to know about SOQL statements. You will learn the optimum way to write complex SOQL statements with this easy-to-understand guide. Beginning with basic SOQL statements, you will progress quickly onto more advanced statements, such as how to filter multiselect picklist values to escape sequences.This book will teach you how to sort records with more than one field, sorting with more than one field-one in ascending order and another field in descending order-and sorting null records in the first or in the last. You will learn about all the features provided while you are writing SOQL statements. This book will make you a SOQL expert by teaching you how to write SOQL statements in an optimized and effective way.ApproachThis is a practical tutorial-based guide on using the new SOQL language, aimed at Force.com developers. Each topic is discussed with the help of standard SOQL queries.Who this book is forIf you are a Salesforce.com developer or administrator, this book will help you to avoid hitting the limits set by Salesforce.com. For those of you who are preparing for the Advanced Developer Salesforce.com certification, this book will also be particularly useful.