-
Daily Popular
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- Unique birthday card wishes for My dear Brother
- No More Spool Space Teradata Query Solution
- Load Delimited Data (csv, excel) into MySQL Server
- Working with EditPlus Text Editor-Regular Expression How To
- Extreme Movie Review: Singham (2011) Ajay Devgn
- Search-find through all databases, tables, columns in mysql
- Selected Oscar Wilde Quotes
- The Dos Chat – Lan Messenger
- Using LOAD DATA INFILE with Stored Procedure Workaround-MySQL
-
query Archive
-
No More Spool Space Teradata Query Solution
Posted on March 2, 2010 | 4 CommentsMore...Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The query: SELECT DISTINCT fieldname FROM tablename; The error:... -
Oracle query-eliminate duplicate but one using rowid
Posted on February 8, 2010 | 1 CommentMore...Yesterday a friend came across an oracle query problem: Consider below table: cid cname.... cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the...