Hi,
How do I write hierarchical queries in postgresql, which I would
write using ‘connectby’ in oracle??
Thanx in adv
Chandan
Hi,
Jus wanted the equivalent for rank() as in tis example..
SELECT *
FROM (
SELECT employee_id, last_name, salary,
RANK() OVER (ORDER BY salary DESC) EMPRANK
FROM employees)
WHERE emprank = 3;
Rgds,
Chandan
Hi,
In oracle we write sysdate-1
For example,we write a query (select *
from table1 where created_date>=sysdate-1).Whats its equivalent in postgre?
Chandan
Hi,
In oracle we write sysdate-1
For example,we write a query (select *
from table1 where created_date>=sysdate-1).Whats its equivalent in postgre?
Chandan
