Using alias in 'where' clause

Question

Using alias in 'where' clause

Closed this issue 11 years ago · 2 comments

sapraaman commented 11 years ago

How do we achieve the following?

select a, fn(b) as c from table where c > 10

Any ideas? Thanks in advance.

Answer 1 · 2014-01-28T15:12:41.000Z

This should be what you're looking for:

https://github.com/brianc/node-sql/blob/master/test/dialects/namespace-tests.js#L43

Answer 2 · 2014-01-28T17:02:21.000Z

Thanks @brianc . But this example talks about table alias. My query is regarding column alias, created after applying function to an existing column. Any idea on that? Can you give me an example for the above query?