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 can you fetch first 5 characters of the string?
Can there be 2 primary keys in a table?
What is a recursive join sql?
How long does it take to learn pl sql?
Why do we use sqlite?
What is the process of copying data from table a to table b?
Does truncate require commit?
How do I truncate a sql log file?
Explain alias in sql?
what is the difference between group by and order by in sql? : Sql dba
Does sql profiler affect performance?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can a trigger call a stored procedure?
How do you update a table in sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
