CrossPlatform SQL Top 10 Results

Here is some handy SQL code that can be used when using BPM Connect to extract from different database platforms. When first connecting to a RDMS in a environment, and when first probing the table structure, it is a good idea to apply a "top" type command (or equivalent) until you get a feel for the data volumes you are working with.

Microsoft SQL Server
SELECT TOP 10 column FROM table

Progress and MySQL
SELECT column FROM table
LIMIT 10

Oracle
SELECT column FROM table
WHERE ROWNUM <= 10

Sybase
SET rowcount 10
SELECT column FROM table

Firebird
SELECT FIRST 10 column
FROM table

DB2
SELECT column FROM table
Fetch first 10 rows only

See here for example of Excel Query