If we make any View in that we use any function to create new column and when we call that view through SELECT statement so can we call that column alias in WHERE clause ?

Question added by Syed Talha Alam , Senior Business Intelligence Consultant , Confiz
Date Posted: 2016/02/04

Upvote (0) Views (5) Followers (1) Answers (1) Report Question

by Rohit Sharma , Technical Consultant , MakePositive Software Solutions Pvt. Ltd.

No we can not use alias in where clause.

Which of the following statements are true regarding the Pareto diagrams?
Top Answer: Option B is likely the answer......... See More

Answers (11)
Which of the following statements are true regarding the Pareto diagrams?
Top Answer: It can be both A & B, or a combination of both A & B. Mostly B although it depends which type of ... See More

Answers (2)
How many Columns Does a "Journal" have?
Top Answer: 5. You can use as many columns as you like. A Journal supports recording of transactions and a business ... See More

Answers (5)
What is rapport mirroring or rapport building on the call?
Top Answer: <p>Rapport is to create warm relation with customer, by be careful with his complaint and agree wit ... See More

Answers (2)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.