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 |
Tell me about a difficult time you had at work and how you worked through it.
what is tracebility matrix.what is tracebility template
What is Web architecture that are followed while doing online project and tell the samples of architecture?
For Editing functionality: If there are 10 fields on survey form.User can edit anything from theese 10 fields. User can edit only first field or he can edit 3 fields at a time or can edit all 10 fields at a time or can edit 1 field of one survey form, 2nd field of 2nd survey form, 3rd field of 3rd survey form etc. upto 10th fields or nothing will edit & close the form . My question is --> I have to write test cases for above all scenarios? Let me know it's urgent.
Integraton testing
what is pass and exit creteria
What is deferred?
difference between load testing and stress testing?
Which are the standards for software test plans?
what is meant by system test case
what is walkthrough?
how test cases are written in test direcror directly or u fetch from xls