CoCreateInstance(...)

CoCreateInstance(Com1,..)

CoCreateInstance(Com2,..)

SELECT	DISTINCT TABLE1.*
FROM		TABLE1
LEFT JOIN 	TABLE2
ON		TABLE1.usr = TABLE2.usr AND TABLE1.value = TABLE2.value WHERE TABLE2.usr is null AND TABLE2.value IS NULL;

SELECT SQL_CALC_FOUND_ROWS DISTINCT ID,Name FROM Table1 WHERE <Condition>
UNION
SELECT DISTINCT

SELECT state, sum( IF( PASS_FAIL = 'P', 1, 0 ) ) AS tp 
FROM ( 
  
  
SELECT inst.state, res. *  
FROM institute inst
INNER JOIN result res ON inst.centrecode = res .original_c 
) 
AS val
group BY state 
LIMIT 0 , 30;

SELECT * FROM products WHERE products.productid IN (SELECT products_categories.productid FROM products_categories GROUP BY products_categories.productid HAVING SUM(IF(products_categories.categoryid

SELECT person FROM my_table GROUP BY person HAVING COUNT(has) = (SELECT COUNT(DISTINCT has) FROM my_table);

SET @sqlQuery := CONCAT('SELECT <field1> FROM <table> WHERE <field2> = <some_value>');
PREPARE stmt FROM @sqlQuery;

SELECT  SUM(MSB.NetQnty) Total 
FROM
	MSA
INNER JOIN 
	MSB
ON 
	MSA.ID = MSB.RefID
WHERE
	MSA.Anchor_ID = intAnchorID
AND 
MSA.Org_ID = intOrgInstance
AND
MSA.InvoiceDate >= DATE_SUB(CURDATE(),INTERVAL 4 QUARTER)
AND

UPDATE participate SET occurrence = IF(vote1 <=  result,vote1 div result,0) + if(vote2 <=  result,vote2 div result,0)

SELECT phone_no FROM Participate WHERE status = 5 and result IN (GREATEST(vote1,vote2,vote3,vote4,vote5));

SELECT * FROM `commentary` WHERE `comments` LIKE '%e%i%p%x%w%r%a%';

SELECT IF('lllle!g g ipg  ggxgg!wfff!rggg!affffx' like '%e%i%p%x%w%r%a%','eesde','nothing');

SELECT * FROM tablename WHERE columnvalue LIKE  '%e%i%p%x%w%r%a%';