how to retrive only second row from table?

Answer Posted / sunita

select * from tab
where rownum=2;

Is This Answer Correct ?    18 Yes 142 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where are cookies actually stored on the hard disk? : Sql dba

795


Which is better cte or subquery?

725


Can sql developer connect to db2?

773


what is a view? : Sql dba

822


Mention what does the hierarchical profiler does?

746


How can I see all tables in sql?

738


How to add a column ‘salary’ to a table employee_details?

782


What are the types of functions in sql?

761


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..

2197


What is basic structure of pl sql?

701


Is sql injection illegal?

782


What does the base_object_type column shows in the user.triggers data dictionary view?

772


Define the select into statement.

788


What is the difference between left join and right join?

680


how to use regular expression in pattern match conditions? : Sql dba

748