Interested to Buy Any Domain ? << Click Here >> for more details...
In my table having 3000 Records. How can I delete the 500th
row? (we don't know what is data inside the table)
- 3 Answers
- 10281 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / suraj kumar pathak
SELECT * FROM (SELECT col1,col2,col3, rownumber() over() AS rn FROM tab1) as tr WHERE rn = 500;
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
how do you reference the printer file formats from cobol programs
How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?
How do you reference the following file formats from cobol programs?
Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?
What is the compute verb? How is it used?
How do u write test cases?
Why occurs cannot be used in 01 level in COBOL?
how do you reference the variable block file formats from cobol programs
What are all the divisions of a COBOL program?
How can you get the ksds file records into your cobol program?
What is a scope terminator give example?
What is the difference between goback, stop run and exit program in cobol?
What is the difference between binary search and sequential search?
Why did you choose to work with ibm mainframe cobol programming?
Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.
