Nested select statement in SQL Server 使用嵌套查询

Categories: Database; Tagged with: SQL • SQL Server; @ August 7th, 2012 11:19

In SQL Server, we need to alias the subquery, otherwise there will be syntax error.

SELECT name FROM (SELECT name FROM users) // Incorrect syntax near ‘)’
SELECT uTable.name FROM (SELECT name FROM users) uTable

 

 

problems with font color in Firefox/Chrome <-> Show/Hide Div using JavaScript

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects