select * from emp where rownum<=2 minus select * from emp where rownum

how to retrive only second row from table?

Question Posted / sushma s

Answer Posted / sushma s

select * from emp where rownum<=2
minus
select * from emp where rownum<2

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is pls integer?

779

What is the sql*loader? : aql loader

779

What is mutating error in pl sql?

750

What is rownum?

711

what is a control file ? : Sql dba

759

Why stored procedure is faster than query?

681

How do I remove duplicates in two columns?

697

How do you declare a variable in pl sql?

746

what's the difference between a primary key and a unique key? : Sql dba

702

What programs use sql?

731

What is sql in java?

756

What is the difference among union, minus and intersect?

731

Explain what is rdbms?

782

What are different clauses used in sql?

813

What does stand for in sql?

718