IS this valid Select A, B, C, A FROM 
Author Message
 IS this valid Select A, B, C, A FROM
Can you select the same field/column more than once?
ie

SELECT a, b, c, a FROM t

?

Thanks.



Mon, 15 Aug 2005 22:44:16 GMT
 IS this valid Select A, B, C, A FROM

Yes, you can with a proper alias like:

SELECT col1,
       col2,
       col1 AS [alias1]
  FROM tbl

--
- Anith
(Please respond only to newsgroups)



Mon, 15 Aug 2005 22:53:43 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Is this a valid ODBC select statement?

2. 8120 - Not valid in Select List

3. create a valid-to column from a valid-from column

4. select unique(0) no longer valid syntax

5. .SC is not a valid valid library file

6. Is this a valid ODBC select statement?

7. 10 year BS!

8. [BS] - Informatica - PROGRAMMATORE VB 6.0 E SQL SERVER

9. B.S. Delphi SQL Error?

10. Designing queries and other VB BS

11. Java/CORBA and Adabas/Natural on BS/2000

12. BS/1 Source Code


 
Powered by phpBB® Forum Software