sql - getting error as too many values in my query -
dpt_no salary period start_date end_date ------ ----- ------ ---------- -------- 100 12580 15months 12-dec-07 10-dec-10 101 15500 19months 10-jan-07 10-dec-11 102 7777 18months 11-jul-07 21-apr-11 103 9999 11months 07-jul-07 31-jan-11 104 8500 9months 12-mar-07 27-mar-11 105 10000 20months 17-sep-07 01-aug-11 106 25000 7months 17-nov-07 26-jul-11 107 100000 6months 05-may-07 21-jun-11 108 35000 16months 28-feb-08 21-jun-11 109 5000 16months 02-dec-08 19-aug-11
i'm write query giving rank salary , getting rank using ampersand. query
select salary salary &rank=(select salary, rank() over(order salary desc) "rank" salary salary).
but i'm getting error "too many values". can 1 me please
it should this:
select t1.salary (select salary.salary, rank() over(order salary desc) "rank" salary) t1 "rank"=&rank
Comments
Post a Comment