Technology Blog
the technology I am interested in and work with
Tuesday, January 11, 2011
print a column using awk and remove dups
›
The following command will print the 3rd column in file input.txt: awk '{print $3}' input.txt Using redirect to output the re...
Friday, January 7, 2011
Select a range from oracle, mysql
›
I talked about how to select first/top n rows from oracle, mysql, and ms sql server. How do we get the range, say from m to n , where m O...
Tuesday, December 28, 2010
Select first n rows from oracle, MySql and MS Sql
›
Assume we have table customer with columns id and age . Find first n customers with youngest ages Oracle select * from (select * from cus...
Monday, December 27, 2010
Oracle merge into with only one table
›
I recently wanted to use oracle MERGE INTO to update a table. With MERGE INTO, it usually works with 2 tables, a source and a target table....
Thursday, December 23, 2010
Git cheat sheet
›
I have been using Git for more than a year. Comparing with SVN, the big difference is how to commit the changes to remote repository. Git...
Friday, September 11, 2009
This is my first post
›
Welcome
‹
Home
View web version