Enjoy Life

A Ryan Gene Blog!

Wednesday, October 25, 2006

[Code]Sql选择字段唯一值并上后面的字段

需求: 选择A字段唯一值,并上B字段,如果A字段相同B字段不同,则取第一次出现的B字段的值。


A B Id
--------------------------------------
1 A 1
1 B 2
2 C 3
2 D 4
3 E 5
3 F 6

选择结果:
A B Id
--------------------------------------
1 A 1
2 C 3
3 E 5



SELECT *
FROM TEST
WHERE (ID IN
(SELECT MIN(id)
FROM TEST
GROUP BY A))

posted by Ryan Gene at 10:54 PM 3 comments

Saturday, October 21, 2006

[Fun]Total广告歌

link:

http://www.jinweijie.com/jinweijie.com/total.mp3

posted by Ryan Gene at 10:02 AM 0 comments

Friday, October 13, 2006

[Software]SourceForge Enterprise Edition

SourceForge 推出了 SourceForge Enterprise Edition

看起来不错! 有空去试试看

15 USERS FREE FOREVER


posted by Ryan Gene at 11:16 AM 0 comments

Sunday, October 08, 2006

[Software]一个很不错的浏览器

K-Meleon


http://kmeleon.blogspot.com/


Gecko引擎,windows native interface

速度快,占资源少,绿色免安装

posted by Ryan Gene at 2:01 PM 0 comments

Tuesday, October 03, 2006

[Software]将物理机转换成vm

周一,VMware发布了VMware Converter 3 Beta版,它可以利用物理计算机系统并将其转换为虚拟机器镜像。新版结合了两个以前独立的两个工具:VMware P2V Assistant 和 Virtual Machine Importer。

除物理机向虚拟机转换外,Converter 3还可以将第三方VM格式转为VMware兼容的镜像,这包括微软的Virtual Server 、Virtual PC 和 Symantec Backup Exec System Recovery。

Converter 3将可以免费获取,下载地址:

http://www.vmware.com/products/beta/converter/

posted by Ryan Gene at 12:15 PM 0 comments

[Software]一些下载电子书的站点

http://www.chmpdf.com/
http://www.chmpdf.com/archives/ebooks/addison wesley/

http://www.templatecn.com/

http://www.vvsoft.net/vvbksd/index.asp

http://book.httpcn.com/

http://www.chinesebook.com.cn/bjbookfair/index.asp

http://www.eshunet.com/

http://www.manyi100.com/

http://www.52ebook.com/

http://www.pcbookcn.com/

http://www.itebook.net/download.asp

http://www.ebookcn.net

http://www.chinaz.com/DownLoad/L/8_...time_Desc_1.asp

http://soft.winzheng.com/SoftList/C...Time_Desc_1.htm

http://www.gd00.com/SoftList/Catalo...ime_Desc_1.html

http://soft.0zones.com/SoftList/Cat...ime_Desc_1.html

补充:

http://ianzag.megasignal.com/ftp/pub/doc/books/Development/

posted by Ryan Gene at 10:02 AM 0 comments

Name:
Location: Shanghai, Shanghai, China

Powered by Blogger
Powered by Writely

Add to Google

Site Feed