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
Powered by Blogger.