基础备忘

--每个选一个： SELECT top (1) with ties a.use_of_proceeds, a.instrument_id, b.primary_name, a.muni_security_type,  a.use_of_proceeds_supplementary, b.apex_asset_typeFROM [ExtFeedData].[rawapex].[debt_muniDetails] as ainner join [ExtFeedData].[rawapex].[masterInformation_instrumentMaster] as bon a.instrument_id=b.instrument_idWhere a.use_of_proceeds_supplementary is not NULLorder by ROW_NUMBER() OVER(PARTITION BY a.use_of_proceeds order by a.use_of_proceeds) --每个条件选十个：SELECT  a.use_of_proceeds, a.instrument_id,  a.muni_security_type,  a.use_of_proceeds_supplementaryFROM (select rid=ROW_NUMBER() OVER(PARTITION BY use_of_proceeds order by instrument_id DESC), * FROM [ExtFeedData].[rawapex].[debt_muniDetails] ) as aWhere a.rid <=10 

MySQL的命令行导入导出：http://www.cnblogs.com/yuwensong/p/3955834.html