how to retrive only second row from table?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / karthik rahul
HI guys
THis Is Karthik Rahul
I think to select the data from second row of a particular
table, we must know at least one coloumn value on that
particular table......
if it is wrong pl. send da correct one ro my mail
karthik_lboy@yahoo.co.in
9985315383 Hyderabad
| Is This Answer Correct ? | 0 Yes | 1 No |
difference between 2 tier and 3tier?and what is the defination of tier?
1 Answers Ybrant Technologies,
Suppose if you have given Login screen to Test. What type of tests r u going to do on that.How many test cases can u write.?
10 Answers Infeneon Technologies,
any body can explain me door lock test cases,cell phone test cases, table and chair test cases
how do you test me?
What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)
Give practical example for implementing V-Model
what are the disadvantages og v-model over waterfall model?
What will u do first when u are asked to start testing ?
4 Answers Scope International,
what is monkey testing?
what is mean by impact analysis ,how we used to select regression TC using this?
What is difference between individual test team testing and self testing by developer? give pros n cons.
What type of Testing u done ur project?