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 |
do we need to write test cases for workflow of the product for instance: there is 2 module "TRAINING ASSIGN MODULE" and "EMPLOYEE" in TRAINING assign MODULE iam assigning training to employee setp is 1.selct traning "oracle" 2.select employee u want assign "peter" 3.apply. now to check whether training assign or not GOTO EMPLOYEE module 1.click on "peter" 2.click on 'view assign to employee'link.now this is a flow do i need to write test cases for this fllow.plz help me guy mail me nirmal_rawatt@rediff.com
what is port testing and do it comes in manual testing?
what is mean by configuration managaement.. explain with example ?
Hello Everyone, I am trying to seek a job in testing. Could someone please send me few real time 'Test Plan','Test Case','Tracibility Matrix'? Thanks, Lakshmi lakshmi.laks@gmail.com
what is agile testing?
Apart from integrating testing,what a test engineer will do in system testing?
1. Write configuration tests for a web based application. 2. How does a plane turn on ground? Explain with logic. 3. How would you test the volume control for a music system? 4. You have been given an application and you have only 15 mins to test the application. How would you do the testing? 5. Your machine, which is on a network has been disconnected. How you debug the problem? 6. What is the sum of numbers from 1 to 1000? 7. What is the probability that on rolling four dices same number appears on all dices? 8. You have been given 8 identical balls out of which one of them is heavier. How would find the heavier ball in the least number of tries with the help of a balance? Explain 9. There is a disc which has been painted half black and half white. You have been given sensors which could detect white or black colors. The disc is revolving in either clockwise or anticlockwise direction with variable angular speed. Find the minimum number of sensors required to determine the direction of rotation of the disc. 10. 64,54,42,31,20 which number does not fit in the series?
What is Snapshot Testing? When we need to do and who will involve in this process and also what is the output document of this testing
how u get the build ?what is the size of the biuld?
you will be given a program and asked to write the Test Data and expected output for the same. for eg: there is a program which returns the sum of largest two numbers in an integer array.
When first time we are testing the screen then we have to write that this screen should contains so & so columns [ suppose there r 10 columns on that screen]in the expected result
I want to do certification in ISTQB please anybody hepl me with the details and site to refer for further details.............if possible give me the material as well on my mail id a.vishwakarma@aol.com. Please help me........Thanks