MySQL Forums
Forum List  »  General

problems-with-alias
Posted by: rodger xd
Date: August 30, 2017 11:50PM

window functions don't support cloumn aliases right now, will you support
it later?
select coalesce(comm,-1) as comm, count(comm) over(partition by comm) as cnt from emp;

Options: ReplyQuote


Subject
Written By
Posted
problems-with-alias
August 30, 2017 11:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.