Categories
Blogs Of Interest
Blog Status
- 4 yrs 33 wks 5 days old
- Updated: 26 Nov 2009
- 438 entries
- 168 comments
Site Map
Total: 1,103,242
since: 5 Apr 2005
since: 5 Apr 2005
LinkBlogS
About those 844 security breaches... 'fess up, Congress tells DHS | The Register
22 June 2007, Friday 7:41 A GMT-06
Clicks: 4601
Hacker breaks into Pentagon email system | The Register
22 June 2007, Friday 7:36 A GMT-06
Clicks: 1644
Bush official goes nuclear in Net Neut row | The Register
22 June 2007, Friday 7:26 A GMT-06
Tags: net neutrality
Clicks: 1606
Clicks: 1287
Man, Can't Microsoft Catch A Break?
16 March 2007, Friday 12:26 P GMT-06
Clicks: 1549
Viacom, Google andYou Tube, Oh My!
16 March 2007, Friday 12:25 P GMT-06
Clicks: 1558
Switch to digital TV to start in October
16 March 2007, Friday 7:46 A GMT-06
Clicks: 1367
Is the Ice Ready? No, Its Still To Hot To Use...
16 March 2007, Friday 7:43 A GMT-06
Clicks: 1421
MIT Entire Curriculum At disposal of e-learners
6 March 2007, Tuesday 11:52 A GMT-06
Clicks: 1262
Clicks: 1670
Windows-on-Mac software gets virtualization update
1 March 2007, Thursday 5:08 A GMT-06
Clicks: 1506
Motorola to create open source high availability operating environment
1 March 2007, Thursday 3:38 A GMT-06
Clicks: 1465
EnterpriseDB is/n't Open Source
1 March 2007, Thursday 3:37 A GMT-06
Clicks: 1638
McKesson First to Offer Red Hat Enterprise Healthcare Platform
1 March 2007, Thursday 3:36 A GMT-06
Clicks: 1306
BitTorrent download portal debuts
27 February 2007, Tuesday 9:05 A GMT-06
Clicks: 1403
$45b TXU buyout
27 February 2007, Tuesday 9:02 A GMT-06
Clicks: 1097
iPhone Competitors Got The Touch
26 February 2007, Monday 3:43 A GMT-06
Clicks: 1226
HTC - Smart Mobility
25 February 2007, Sunday 4:22 A GMT-06
Clicks: 1522
Turning Service-Oriented Events into Business Insight @ SOA WORLD MAGAZINE
24 February 2007, Saturday 5:15 A GMT-06
Clicks: 2067
Hard to find 1-800 numbers
23 February 2007, Friday 8:35 A GMT-06
Clicks: 1126
Cuba Embraces Open-Source Software
21 February 2007, Wednesday 3:10 A GMT-06
Clicks: 3114
Clicks: 1603
PostgreSQL Open Source And Persistence
3 February 2007, Saturday 10:32 P GMT-06
Clicks: 2060
Blackboard Pledges No Patent Blocks
3 February 2007, Saturday 10:28 P GMT-06
Clicks: 1242
UVU
5 January 2007, Friday 11:58 P GMT-06
Clicks: 1347
Open-source IP PBX software appliance"
4 January 2007, Thursday 3:44 A GMT-06
Clicks: 1236
Asterisk an under-appreciated Open Source Success Story
4 January 2007, Thursday 3:43 A GMT-06
Clicks: 1397
Open Source AJAX Tooling
4 January 2007, Thursday 3:41 A GMT-06
Clicks: 1409
Clicks: 1521
United States Patent Application: 0060288329
26 December 2006, Tuesday 4:00 A GMT-06
Clicks: 1524
LinkBlog Popular Tags
August 16, 2012
Time Left
2 years 8 months 15 days
New Design: RedTie by alexisc22
24 May 2009, Sunday
alexisc22's "RedTie" was just added to OSWD! It is white and red and validates XHTML 1.0 Transitional.
New Design: Simple Beauty by dboy
24 May 2009, Sunday
dboy's "Simple Beauty" was just added to OSWD! It is white and gray and validates XHTML 1.0 Strict.
New Design: Rounded_2 by jedignork
24 May 2009, Sunday
jedignork's "Rounded_2" was just added to OSWD! It is blue and white and validates XHTML 1.0 Strict.
New Design: Delicious Fruit by Dieter
24 May 2009, Sunday
Dieter's "Delicious Fruit" was just added to OSWD! It is yellow and green and validates XHTML 1.0 Strict.
New Design: Touching by timmytima
24 May 2009, Sunday
timmytima's "Touching" was just added to OSWD! It is white and black and validates XHTML 1.0 Transitional.
New Design: BlackandGreen by shipping_guy
24 May 2009, Sunday
shipping_guy's "BlackandGreen" was just added to OSWD! It is orange and green and validates XHTML 1.0 Strict.
New Design: Sundark by rotw
24 May 2009, Sunday
rotw's "Sundark" was just added to OSWD! It is black and yellow and validates XHTML 1.0 Transitional.
New Design: Cash by alexisc22
24 May 2009, Sunday
alexisc22's "Cash" was just added to OSWD! It is green and gray and validates XHTML 1.0 Transitional.
New Design: Greeny blu by heartlessg
24 May 2009, Sunday
heartlessg's "Greeny blu" was just added to OSWD! It is black and blue and validates XHTML 1.0 Transitional.
New Design: Cloudy Water Sports by boilers
24 May 2009, Sunday
boilers's "Cloudy Water Sports" was just added to OSWD! It is gray and blue and validates XHTML 1.0 Strict.
This week at LWN: On GNOME and its Foundation: an interview with Luis Villa
24 May 2009, Sunday
LWN recently posted a brief article on the GNOME Foundation's plea for support to help it get through a difficult year. Some of the comments on that news questioned the role of the foundation and its
Poseidon USB Stack Bounty Reached: Open Source, AROS Port
24 May 2009, Sunday
Another important bounty quota has been reached in the Power2People website, and this time the result comes from a common effort of the whole Amiga/Morphos/AROS Community. The result of this bounty be
Where to buy Preinstalled Linux Laptop/Desktop
24 May 2009, Sunday
Installing any OS can still sometimes be a tedious task and one that scares the wits out of the average computer user. And, it’s just more fun to buy a computer with Linux already on it and not have t
Microsoft and ODF: Bad for Everyone
24 May 2009, Sunday
Microsoft finally agreed to implement ODF support in Microsoft Office, but they didn't do it quite right, hurting both Microsoft and the ODF specification.
Linux MMORPG Game Engine Sees Major Update
23 May 2009, Saturday
Regnum Online, a Massively Multi-player Online Role Playing Game that has a native Linux client offered by its developers (NGD Studios), has received a major overhaul. Regnum Online is one of the very
Discovery: The Ultimate Linux Device - The Kickfire Appliance
23 May 2009, Saturday
Discover the Kickfire appliance--if this isn't the ultimate Linux device, one might not exist.
Some Funny Linux/Computer Pictures
23 May 2009, Saturday
More funny pictures from the "world wide interweb" - I think that's what Mr. Monk calls it ;)
The Acer Debacle - Closing the Chapter
23 May 2009, Saturday
Michelle Minkin, a friend of this effort and an all-around nice lady; suggested that we auction off the opportunity to destroy these computers. We were almost ready to start soliciting the community f
Cisco Settles, But Where From Here?
23 May 2009, Saturday
Until September 20, 2007, nobody had ever sued anybody for violating the General Public License (GPL) — not a single company, project, or individual developer in the license's then-eighteen
OpenBSD 4.5 update: Reinstall goes quickly, X still in trouble; still running Ubuntu 8.04
23 May 2009, Saturday
I'll keep this quick. I followed the advice of Nathan from OpenBSD101 and replaced my upgraded OpenBSD 4.5 installation with an entirely new, reinstalled system. That took all of 10 minutes. I followe
Desperation, Scare Tactics, and Happy Memorial Day!
23 May 2009, Saturday
I love to poke fun at tech vendors who continually boast of their innovation, when in fact they're scared to death of real innovation, if they could even recognize it. Today I poke fun at the anti-mal
Archives
- November 2009
- October 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- July 2005
- June 2005
RSS Add-Me
Google Related Links
TOP N For Oracle, SQLServer & MySQL
posted 2 April 2007, Monday
If you are like me and you are in Oracle, PostgreSQL, SQL Server, MySQL and Firebird. day in and day out its syntax for either of these RDMS can be inconsistant. I need a reference. Syntax to limit the results on a simple select vary among the RDBM's listed above.
So, here's a hint. Assuming a table of USERS, with fields userid, username, email.
SELECT userid, username, email
FROM users
WHERE ROWNUM <= 10
FROM users
WHERE ROWNUM <= 10
SELECT userid, username, email
FROM users
LIMIT 10
FROM users
LIMIT 10
SELECT Top 10 userid, username, email
FROM users
FROM users
SELECT userid, username, email
FROM users
LIMIT 10
FROM users
LIMIT 10
SELECT FIRST 10 userid, username, email
FROM users
FROM users
tags: oracle sqlserver postgresql mysql firebird select limit records sql
links: digg this del.icio.us technorati reddit