Saturday, September 12, 2009

Select Statement for Different Database

Database SQL Syntax
- Different databases using different sql statement

DB2
select * from table fetch first 10 rows only

Informix
select first 10 * from table

Microsoft SQL Server and Access
select top 10 * from table

MySQL and PostgreSQL
select * from table limit 10

Oracle 8i
select * from (select * from table) where rownum <= 10

1 comment:

GuildWars2Items said...

You laugh at me for being different, but I laugh at you for being the same RuneScape Gold, The consequences of today are determined by the actions of the past RS Gold, experience is a hard teacher because she gives the RS GP test first, the lesson afterwards.

You have a forever friend for life, and forever has no end D3 Gold Sale, and if you find such a friend, you feel happy and complete, because you need not worry Diablo iii Gold, your forever friend holds your hand and tells you that everything is going to be okay Buy Diablo iii Gold.