how to retrive only second row from table?

Answer Posted / magesh n

My answer will work in Oracle SQL but not sure in MS-SQL.
Query is:

select * from tablename where rownum=2;

rownum is the pseudo-column in oracle sql.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are metrics and what are metrics did u collect in you are project

1927


What is the limit for test steps?It should be 10/20/30etc

1494


In which all places, testing is done?One is from the server by calling server name.Can u suggest others?

1480


what are the test bugs

1497


Give me an example of something you tried at work but did not work out so you had to go at things another way.

1646






In our project, we use Withdrawal Indent, we are confused to use heading as "Withdrawal Indent" or "Withdraw Indent". Please suggest me which one to use ASAP, Thanks in advance

1542


Hi, what do you mean by internal auditing? what are the things they do in internal auditing?what they review? THNX in Advance

1662


Anybody having documents and URLs about BFSI domain...Please share..it is really urgent

1965


1. what exactly is heuristic checklist approach for unit testing ?

2224


functional testing test cases for transfer funds ?

1198


I need your help, actually am facing lots of problem in interview am not able to answer in right way what ever questions asked about project. Could you please answer few questions? You must have seen the project I have mention as current project so please help on this, tell me how to explain project in details am prepare on HR module but don’t know how to explain it properly. If you can send me few documents like SRS, and few test case that will help me to get the clear picture, and want ask u what is tier1, tier2, and tier3 in project.

1484


Can you explain tailoring?

700


How to do security implementation for any URL??

1424


When we are recording in WinRunner and interact with the AUT, what does WinRunner do?

1597


How do you go about testing a project?

1535