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
- 10151 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
what is s000 u4087 error? please give the all error codes in cobol,jcl.
What is a scope terminator give example?
What is the difference between structured cobol programming and object alternativelyiented cobol?
What is static and dynamic call in cobol?
What are the rules of the move verb?
Whats the difference between search & search ALL?
What is the default value(s) for an initialize and what keyword allows for an override of the default?
What are literals?
how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)
Discuss about changing dataset name in proc.
2 input fles: 2 flat files, with different number of records. both are having unique key for each record and already sorted in ascending order . match these files using unique key and in output only matching key value has to be written. please procide cobol logic
how do you reference the ksds vsam file formats from cobol programs
how we sort two input files based on a common column and giving one o/p file please send me the coding logic?
What kind of error is trapped by on size error option?
Explain how you can characterize tables in cobol?
