Answer / ssd

SELECT username, email, COUNT(*) FROM users
GROUP BY username, email HAVING COUNT(*) > 1

What is the purpose of Panel Groups?

4 Answers  

---

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  

---

can we use cl programming to update or delete physical files

12 Answers  

---

When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

0 Answers  

---

give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........

0 Answers   CTS,

---

difference betwen keywords and opcodes

3 Answers  

---

Delete FileName at first statement in RPG.

1 Answers  

---

What is the purpose of FRCDTA keyword?

3 Answers   IBM,

---

what is the procedure and explain about real time scenario.

0 Answers   Adhoc Technologies, Hanuman Automation, HSBC, IBM,

---

what is data area and how it is used in rpg program ?

0 Answers   IBM,

---

What you have to do in the display file when you are using message subfile?

1 Answers  

---

1.How can you search an entire source file for a particular field name? 2.How can you find the differences between two versions of the source for the same program? 3.What is a hidden field as it relates to a sub file? 4.How do you display a sub file that has no records in the sub file?

8 Answers   HCL,

---