Answer Posted / priya
select * from emp where empno < (select max(empno) from
emp) and rownum<2 order by empno desc
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
can a stored procedure call itself or recursive stored procedure? : Sql dba
How many types of index are there?
How to test for null values?
What is sql and db2?
Why stored procedure is faster than query?
Why commit is not used in triggers?
What is user in sql?
what are the disadvantages of mysql? : Sql dba
what are the differences between binary and varbinary? : Sql dba
Does a join table need a primary key?
Name three sql operations that perform a sort.
How do you rename a table in sql?
How many types of normalization are there?
Can a composite key be null?
what is union, minus and interact commands? : Sql dba