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 is an mr?

1152


Why should you care about objects and object-oriented testing?

2391


Please can any one tell me 1).Types of reports 2).Types of Meetings.

1843


online demo for bug tracker tool(let me know the website)

2144


How many types of api testing are there?

1153


What is reverse engineering?

1228


Can anyone please tell in detail about the Rally tool and how a tester is going to use it.

2567


Diffrernce between client server testing and web server testing.

2239


What is Registry?

2104


hi, this is geetha, i have one doubt regarding the vulnerability testing. For sql injection testing is there any need for the tools to be installed. If it is what is tool and what is the method to test in sql injection testing. Plz Guide me

2054


Please explain me v-model clearly i want to know how it works and want to know how it use in real time on a project please tell me its urgent and important for me understand .Please tell me my mail id is Chiku_69@yahoo.in Thank u

2626


1.Tell me negative test cases for notepad 2.Tell me the factors for for writing severity based test cases

6391


in transfer funds module, how you come to know that amount has been transferred successfully or not....explain in detail

1609


Hi to all, im vaibhav i joined a MNC as a tester and i got a banking (HSBC) project can any one tell me as a fresher what kind of strategy i sholud use to perform better. thanx

2370


How could you present test strategy for the product testing?

1078