Answer Posted / rajasekar.p
select * from (select a.*,rownum aa from orders a )
where aa=2
Please verify the same you will get the correct answer
Regards
P.Rajasekar
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How to call a javascript function from pl sql?
How to call shell script from pl sql procedure?
What are the two types of exceptions.
Is crud a cuss word?
How do you change a value in sql?
How do I save a sql query?
How to sort the rows in sql.
what is online transaction processing (oltp)? : Sql dba
What is sql character function?
What are keys in sql?
What is view? Can we update view
What will you get by the cursor attribute sql%found?
how to calculate the difference between two dates? : Sql dba
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What are sql built in functions?
