Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 10997 Views
- I also Faced
- E-Mail Answers
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
explain sflclr, sflend, sfldlt, and sflcsrrrn?
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
what is the necessary keyword needed to scroll subfile records?
What is a record lock error?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
what is the procedure and explain about real time scenario.
How would display prime numbers using CL program?
What are the types of identifiers?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
what is an online rpg?
how do I declare a minor?
what is the use of sflnxtchg?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
How to write record if no field or the field are different in physical file in rpgle ?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
