how to retrive only second row from table?

Answer Posted / sandhya rani

This is perfect answer...
and do not misguide the ppl by simply writing wrong answer.
until and unless u r perfect..pls do not share your answer


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

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write an sql query to find names of employee start with 'a'? : Sql dba

773


Is sql a scripting language?

690


what is the difference between delete and truncate statement in sql? : Sql dba

759


what are all the different normalizations? : Sql dba

683


Is sql similar to python?

714






What are keys in sql?

722


What is the difference between cross join and natural join?

753


What is having clause in sql?

714


What is output spooling in sql*plus?

741


how can I make a script that can be bi-language (supports english, german)? : Sql dba

728


What are hotfixes and patches?

689


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2176


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

721


What are the dml statements?

852


What operators deal with null?

813