how to retrive only second row from table?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to drop an existing view in mysql? : Sql dba

543


how to add a new column to an existing table in mysql? : Sql dba

559


Can triggers stop a dml statement from executing on a table?

588


What is oracle pl sql developer?

503


What are the two types of cursors in pl sql?

507






Does sql view stored data?

509


explain what is mysql? : Sql dba

570


What is exception? What are the types of exceptions?

532


How do you change a value in sql?

528


What are triggers and its uses?

568


Explain architecture of sql server notification services?

596


What is string data type in sql?

505


What is the difference between drop and truncate commands?

462


How do I find duplicates in a single column in sql?

509


What is consistency?

681