Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 will be the QA roles and responsibilities in Health care stream like BCBS,can someone please explain me any example project regarding health care services in web-based application?

2160


How can you do the scalability testing?

1166


Katari your questions was really helpful could you please send the questions and answers with them . Can anyone sends the top 30-40 question and answers for the interview purposes

1809


How to test whether the application is having memory leakage using task manager and PerfMon. Please tell if any one know. thanku

1957


What is the difference between stlc and sdlc?

1028


What is verification in software testing?

1119


what are all the possible Test Cases for VoIP based applications

1701


Explain thread testing.

1023


Why is it impossible to test a program completely?

1494


Diffrence b/w functional testing,functionality testing,system testing?

2041


what is the architecture of your current project?

2413


what types of testing you performed in transfer funds module....

1638


tell me brief about your project? please help me how to explain the project what is the flow? my current project is ERP domain web based application. please help me

1981


What about the test case if the field only takes a certain number of characters or a minimum number?

1122


is it possible to do performance testing in stand alone application..how wil u do that ???????

2217