-- MySQL, Oracle
CREATE TABLE bar AS SELECT * FROM foo WHERE 1 = 2

-- SQL Server
SELECT * INTO bar FROM foo WHERE 1 = 2

-- DB2
CREATE TABLE bar LIKE foo

-- MySQL
SELECT * FROM table LIMIT 10

-- Oracle
SELECT * FROM table WHERE rownum <= 10

-- SQL Server
SELECT TOP 10 * FROM table

INSERT INTO baz VALUES(DEFAULT)

SELECT foo, bar, 
	CASE	WHEN num > 100 THEN 'big number'
		WHEN num < 100 THEN 'small number'
		ELSE 'exact number'
	END AS num_string
FROM baz

SELECT COALESCE(foo,0) FROM table

-- MySQL
SELECT CONCAT(foo,' glued to ',bar) FROM baz

-- DB2, Oracle
SELECT foo||' glued to '||bar FROM baz

-- SQL Server
SELECT foo + ' glued to ' + bar FROM baz