You need to alias the subquery.
SELECT name FROM (SELECT name FROM agentinformation) a
or to be more explicit
SELECT a.name FROM (SELECT name FROM agentinformation) a
More Related Contents:
- Difference between CTE and SubQuery?
- Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
- Difference between Subquery and Correlated Subquery
- Best way to do nested case statement logic in SQL Server
- Get Parent with multiple children in desc order
- How can I schedule a job to run a SQL query daily?
- Convert Month Number to Month Name Function in SQL
- SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
- Reset identity seed after deleting records in SQL Server
- How to avoid the “divide by zero” error in SQL?
- Multiple INSERT statements vs. single INSERT with multiple VALUES
- Limit on the WHERE col IN (…) condition
- Removing leading zeroes from a field in a SQL statement
- How to simulate UNPIVOT in Access?
- Real life example, when to use OUTER / CROSS APPLY in SQL
- Getting result of dynamic SQL into a variable for sql-server
- Better techniques for trimming leading zeros in SQL Server?
- Dynamic Pivot Table in SQL Server
- Optimized SQL for tree structures
- How to insert a blob into a database using sql server management studio
- Joining multiple tables in SQL
- Get the character between first 2 special character in SQL
- Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
- SQL count consecutive days
- Inner Joining three tables
- SELECT max(x) is returning null; how can I make it return 0?
- How to return default value from SQL query
- SQL INSERT INTO from multiple tables
- How to Execute SQL Query without Displaying results
- Conditional aggregation performance