Vikaskumar Pandeysalesforcesherpa.hashnode.dev·May 23, 2023Query Five Levels of Parent-to-Child Relationships in SOQL QueriesIf you're a developer working with Salesforce, you're likely familiar with the powerful SOQL (Salesforce Object Query Language) tool. SOQL enables you to retrieve data from Salesforce's various objects, including parent and child objects. In this art...Discuss·42 readsParent-to-child relationships
DbVisualizerforThe Tablethetable.hashnode.dev·Apr 28, 2023A Guide to Subqueries in MySQLSubqueries are a part of the life of every DBA. Everyone knows that subqueries are just that – they’re queries within queries, but they’re actually so much more than that. Intrigued? This blog will walk you through everything you need to know about t...DiscussMySQL
Vikaskumar Pandeysalesforcesherpa.hashnode.dev·Apr 25, 2023Query Five Levels of Parent-to-Child Relationships in SOQL QueriesIf you're a developer working with Salesforce, you're likely familiar with the powerful SOQL (Salesforce Object Query Language) tool. SOQL enables you to retrieve data from Salesforce's various objects, including parent and child objects. In this art...Discuss·10 likes·89 readsSalesforce
Amit Lambasynaptiq.dev·Mar 9, 2023The Power of SQLIntroduction In the following series, we’re going to explore some of the intermediate to advanced techniques available to us when using an SQL or relational database. We’ll assume you have some basic experience with the Structured Query Language (SQL...Discuss·47 readsSQL
DbVisualizerforThe Tablethetable.hashnode.dev·Mar 6, 2023The Complete Guide to SQL SubqueriesLet’s learn everything you need to know to master subqueries. Reduce the number of queries you perform and start embedding advanced query logic into single SQL queries. Many logical operations require several queries to be executed or involve queries...Discuss·41 readssubqueries
Gaurav Meherkhambgauravmeherkhamb.hashnode.dev·Jan 9, 2023SQL Subqueries: SimplifiedA subquery is a SELECT statement that is nested within another SELECT, INSERT, UPDATE, or DELETE statement, or within a SET clause of a SELECT statement. Subqueries can be used to return data to the main query or to filter the results of the main que...Discuss·29 readssubqueries
Khanh Nam Doblog.donamkhanh.com·Dec 18, 2015How to use sub query in MySQL DELETE statement?Just simple as bellow: DELETE FROM clients WHERE id NOT IN ( SELECT * FROM ( SELECT c.id FROM products p INNER JOIN clients c ON c.id = p.supplier_id WHERE c.name = 'Q-IMAGING AUSTRALIA LTD (HEAD OFF...DiscussMySQL
