compare reference.jpeg to-be-tested.jpeg -compose src diff.jpeg

SELECT *
FROM table1 as t1
LEFT OUTER JOIN table1 AS t2
ON (left(t1.col1,LEN(t1.col1) - 3)= left(t2.col1,LEN(t2.col1) - 3) AND t1.col2 < t2.col2)
WHERE t2.col1 IS Null

select left(col1,LEN(col1) - 3) as , MAX (col2) from table1 group by col1

select left(col1,LEN(col1) - 3), MAX (col2) from table1 group by col1

select left(col1,LEN(col1) - 3), MAX (col2) from table1 group by col1

 select col1, MAX

class Animal {
      public void eat(){

	  System.out.println("Animal eats");
      }
}

class Dog extends Animal {
      public void eat(){ 
          System.out.println("Dog eats");

    select [B]orderitems.[/B]orderID, [B]orderitems.[/B]ItemID 
    from orderitems 
    inner join (
       select orderID 
       from orderitems 
       where itemID =889
    ) x on orderitems.orderID = x.orderID

select orderID, ItemID from orderitems where orderID in (select orderID where itemID =889)

or
select orderID, ItemID from orderitems inner join select orderID from orderitems where itemID =889

SELECT  *
FROM    patientdata mto
WHERE   EXISTS
        (
        SELECT  1
        FROM    patientdata mti
        WHERE   mti.dob = mto.dob
        LIMIT 1, 1
        )

tom	hanks	        mi	10	2
jon	trevolta	nj	13	2

tom	hanks	        mi	10	
tom     hanks           md      10
jon	trevolta	nj	13	
jon	trevolta	nj	13

SELECT *, 
COUNT(dob) AS NumOccurrences