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 rank function in sql?

965

Why do we use %rowtype & %type in plsql?

994

what is error ora-03113: end-of-file on communication channel?

1084

What is self-join and what is the requirement of self-join?

1089

What is the difference between execution of triggers and stored procedures?

1053

Why stored procedure is faster than query?

951

What is the unique index?

1005

What does subquery mean in sql?

992

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1976

Is vs as in pl sql?

935

Is sql injection illegal?

964

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

955

Can we use views in stored procedure?

971

How does postgresql compare to oracle/db2/ms sql server/informix?

983

How do you use join?

890