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
- 10996 Views
- I also Faced
- E-Mail Answers
Answer Posted / s kumar
Q1:select Emp_name from Table-Name group by Emp_name having
count(Phone)=2
Hope it'll work out.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is ment by record level identifier?
Q:HI friends accually ihave one problem plesase let me know the alternate code of this code. Related field description of code: Add a field, CALvsPRD, "Calendar Day Starts Before/After Production Day" to the parameter set WRKORDER which accepts values 'A' or 'B' o B = Calendar Day Starts Before Production Day o A = Calendar Day Starts After Production Day o Any other value indicates the production and calendar dates are always the same. code: Automatic Execution Of *INZSR Subroutine /Z01 * retrieves WRKORDER field values. /Z01 * Calculate default Production Date and return it to caller. /Z01 * Production date defaults to system date /Z01 C Eval P@Pdate = %DATE() /Z01 * unless Calendar date starts Before PDN(production) date and /Z01 * system time is before PDN Start Time then /Z01 * PDN date is yesterday. /Z01 C If W@CALvsPRD = 'B' and /Z01 C %TIME() < %TIME (W@Strtime) /Z01 C Eval P@Pdate -= %Day(1) /Z01 * unless Calendar date starts After PDN date and /Z01 * system time is *GE PDN(production) Start Time then /Z01 * PDN date is tomorrow. /Z01 C ElseIf W@CALvsPRD = 'A' and W@Strtime > *Zero and /Z01 C %TIME() >= %TIME (W@STrtime) /Z01 C Eval P@Pdate += %Day(1) /Z01 C EndIf /Z01 C Eval *InLr = *On
what is kids-rpg?
What is the purpose of record level identifier?
How to write record if no field or the field are different in physical file in rpgle ?
what is the use of sflnxtchg?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
how can I tell when to replace the array?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
How to handle duplicate error handling in RPG?
What is the difference between iter and do?
what is data area and how it is used in rpg program ?
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
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 create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
