SQL cheatsheet.

My sql

SELECT x.a
FROM
( SELECT ’1′ AS a
UNION ALL
SELECT ’2′
UNION ALL
SELECT ’3′
) x
WHERE a NOT IN
( SELECT knr FROM table1 )

SELECT t.CHANNEL
, COUNT(*) / SUM(grp.TotalCount)
FROM my_table t
JOIN
( SELECT LOC_CODE
, COUNT(*) TotalCount — or is it perhaps?:
— COUNT(DISTINCT CHANNEL)
FROM my_table
GROUP BY LOC_CODE
) grp
ON grp.LOC_CODE = t.LOC_CODE
GROUP BY t.CHANNEL

My delete:

DELETE
FROM table
WHERE id IN
( SELECT id
FROM table
WHERE obsolete = 1
ORDER BY id
FETCH FIRST 100000 ROWS ONLY
)

Tizen Linux for mobile tablet smartphone will takeover the world. Backed by Intel, Samsung, Linux foundation. Good luck.

Tizen Linux for mobile tablet smartphone will takeover the world. Backed by Intel, Samsung, Linux foundation. Good luck.

- Android is less important in such case

- IPhone also

 

Sony use Linux? Sony ericsson has open source linux called “xperia”.

Giant Sony, Quality Sony uses finally Linux, never discovered by nobody ?

Sony ericsson: has there own operating system calls Xperia which is actually Android, before they were using Windows mobile platforms

Sony: themselves obviously is using Linux but they kept top secret, my guess is its either using JavaOS or Linux

- Great to know if somebody care to tell!

 

 

Ubuntu now runs in Android. Finally C programmers are happy to have there GCC back in the mobile battle.

Ubuntu is now running on top of Android. Soon there will be no more NDK/SDK requirement. Android made a mess mistake for GCC developers. Everything in past need to use NDK/SDK to retype every single lines to JNA code, which is idiot implementation actually of Android.

- Android Ubuntu will then allow GCC

- Tizen linux from Intel, Samsung will soon release there dragon Linux with GCC support to take-over Android, IPhone

 

NeBeans IDE 7.2 is almost ready. The Best IDE ever then Eclipse :)

NeBeans IDE 7.2 is almost in stable release. There was Github problem in the nightly release.

 

MySQL is 70x faster then before.

MySQL cluster has 70x speed.