*** 168,175 ****
SUM(CASE WHEN y.Hours >= x.Hours
THEN 1 ELSE 0 END)>=(COUNT(*)/2)+1
! *: join syntax (+) (-) like oracle has - _SQLite used to have this but it
! was removed because it is not standard SQL._ *RETURN IT BACK AGAIN, PLEASE!!!*
*: name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)
--- 168,184 ----
SUM(CASE WHEN y.Hours >= x.Hours
THEN 1 ELSE 0 END)>=(COUNT(*)/2)+1
! *: Oracle's wacky, nonstandard join syntax using (+) and (-):
!
! SELECT a1.a, a1.b, a2.a, a2.b
! FROM a1 LEFT JOIN a2 ON a2.b = a1.a
!
! _:...can be written in Oracle as:
!
! SELECT a1.a, a1.b, a2.a, a2.b
! FROM a1, a2
! WHERE a1.a = a2.b(+);
!
*: name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|