基础备忘

--每个选一个： 
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_type
FROM [ExtFeedData].[rawapex].[debt_muniDetails] as a
inner join [ExtFeedData].[rawapex].[masterInformation_instrumentMaster] as b
on a.instrument_id=b.instrument_id
Where a.use_of_proceeds_supplementary is not NULL
order 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_supplementary
FROM 
(select rid=ROW_NUMBER() OVER(PARTITION BY use_of_proceeds order by instrument_id DESC), * 
FROM [ExtFeedData].[rawapex].[debt_muniDetails] ) as a
Where a.rid <=10 

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