Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 ?

Programming SQL
user-image
Question added by Syed Talha Alam , Manager Research and Data Analytics , K-Electric
Date Posted: 2016/02/04
Upvote (0) Views (5) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Rohit Sharma
by Rohit Sharma , Technical Consultant , MakePositive Software Solutions Pvt. Ltd.

No we can not use alias in where clause.

Write Your Answer
More Questions Like This