`
luhantu
  • 浏览: 207041 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论

Oracle union order by & SqlServer union order by

阅读更多

Oracle数据库的union 操作为:

 

select * from (select * from table1 union select * from table2 ) order by column1Nameasc, column2Name asc

 

 

 SqlServer数据库的union操作为:

 

select * from table1 union select * from table2 order by column1Name asc, column2Name asc

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics