Saiko Consulting's SqlChallenge

Home
Why It Works How It Works
Daily Challenge
Challenge Winners Contact

Companies

Recruiter Tools

Post SqlAds

Resume Razor

Candidates

Training

Intro to

Informatica

Top 10

grabowski

vlg

anjugarg

billw

jjahns

drj

nisha

nishardhini

grifman

kalaabhyas

Yesterdays Results
86% Correct
14% Incorrect

Sponsored Jobs

Database Programming Specialist

Atlanta, GA

Advanced SQL query experience; - Five years of experience in software development; - Experience in building web-based programming applications with relational databases in a multi-tier environment more...

DataStage Developer

Iowa, IA

DataStage, Informatica, Oracle, Team Leader more...

IT Analyst (business analyst)

Bristol, CT

documentation, user interaction re: full sdlc responsibility. Security access, full sdlc, post-requirement. more...

Data Modeler

Shelton, CT

UML, Rational, RequisitePro more...

Project Manager (Multiple)

Windsor, CT

Junior to Senior Level Project Managers with Insurance Background more...

Production Support Analyst - Unix, FTP

Bristol, CT

Momentum, Odin, ConnectDirect, Tidal, BARR, and Tandem application and O/S software more...

Data Analyst

Shelton, CT

MSAccess, SQL Sever, SQL, DBase, Clipper, Foxpro more...

Read A Topic

Return To Topics	Originally Posted: 6/23/2006 7:27:18 PM
	Last Updated: 6/23/2006 7:41:25 PM

Subject:

DailyChallenge 06/22/2006

You Asked....

I got today's question wrong and had a reference which seems to suggest I might have been right or that the question might be ambigious :

Source : http://publib.boulder.ibm.com/infocenter/rb63help/index.jsp?topic=/com.ibm.redbrick.doc6.3/ssg/ssg32.htm
A column alias can occur anywhere in a SELECT statement to designate the column to which it refers (for example, in a WHERE, ORDER BY , GROUP BY, or HAVING clause).

Important:
If the value contained in the column referenced by the column alias is the result of a set function, it cannot occur in the WHERE clause; however, it can occur in the HAVING clause.

Can you mail me for a clarification.

Question:

When a column is aliased in a SQL statement which of the following can utilize the column alias rather than having to use the names of the column from the table?

Example:

SELECT quantity*discount extprice FROM OrderDetails

and we responded....

I read your reference and you are correct.

However, this seems to be specific to a RedBrick implementation.

ANSI-SQL allows a column alias to be used on the ORDER BY clause but not on the HAVING, GROUP BY or WHERE.

others said....

Post Your Own Review