SQL SELECT TOP N equivalent in ORACLE and MySQL
Something I needed today... I wish this was standarized, but it is not, so here are some examples:
SQL Server:SELECT TOP 10 product, descr, email
FROM products
ORACLE:
FROM products
SELECT product, descr, email
FROM products
WHERE ROWNUM <= 10
MySQL:
FROM products
WHERE ROWNUM <= 10
SELECT product, descr, email
FROM products
LIMIT 10
FROM products
LIMIT 10
Sponsored Links
Archives By Subject
BlogCFC (2)Coldfusion (18)
CSS (4)
Design (5)
Javascript (1)
Life (7)
PhotoShop (5)
SQL (5)
Technology (5)
The Web (7)
Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 |
Recent Comments
Multiple SQL inserts: Oracle, Mysql, MssqlJAYESH TALSANIYA said: in mssql u cannot use parentheses in select statement. use as below: INSERT INTO [TABLE] (column1,... [More]
Multiple SQL inserts: Oracle, Mysql, MssqlJD said: I found with MSSQL, I couldn't use parentheses in my select statements for insert. So, from your ex... [More]
BlogCFC ping list and timeoutsWill Wilson said: Nice :) that will come in handy, thanks! [More]
Is this a Coldfusion 8 BUGBarb said: I'm having the same problem . . . when I start CF8, it seems to hang during or just after the user M... [More]
Is this a Coldfusion 8 BUGJoão Fernandes said: Phil, when you install CF8 they give you an option to install LCDS within CF. The messageBrokerServl... [More]
Bookmarks
Russ Michaels blogw3csites.com
riaforge.org
smashingmagazine.com
coldfusioncommunity.org
succor.co.uk
cssplay.co.uk
hotukdeals.com
feedicons.com
coldfusionjedi.com
alistapart.com
photoshopcandy.com
Recent Entries
Eclipse Oracle PluginWhere is my iPhone - o2 poor servic
Cheapest iPhone on the internet
Is this a Coldfusion 8 BUG
Online CSS Layouts designer
W3C Design Gallery
Feed temporarily down.
There are no comments for this entry.
[Add Comment]