1..Write an sql query to find the employee name who is
having 2 phone numebr?
2.Write an sql query to the the second highest salary of
the employee?
Answer Posted / naga srinivas.kattula
1. select * from filemame phn1 ne ' ' and phm2 ne ' '
Using above query u can get the which employee have 2 phone
numbers
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
do you use message subfiles? What are the necessary keywords required coding a message subfile?
What is a record lock error?
How to handle duplicate error handling in RPG?
How many program bind in one module....
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
How to write record if no field or the field are different in physical file in rpgle ?
How to call one program from another program in RPG? please help me with the code
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
what is *place and *auto keyword in prtf ?plz explain
what is kids-rpg?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
how do I declare a minor?