Answer Posted / swapna

Hcl Placement Papers | Hcl Interview Procedure |
Hcl Aptitude Questions | Hcl Technical Questions
|Hcl Interview Questions


2 Tables will be there

Namely Employee having columns like Empid,Empname,Salary,Mgrid.

Phone Table having Empid and Phone number.

Based on these some questions like this

1) select all the Employees who does not have phone?

2)Dispaly all managers from table(Manager id is same as Empid)

3)How to know How many tables contain Empno as a column in database?

4)Find duplicate rows in a table or if we have table with one column which
has many records which are not distinct. How to find out the distinct
values from that column and number of times it's repeated?

5) How to delete the rows which are duplicate?(Don't remove both duplicate
records.)

6)How to find the 6th highest salary?

Hcl Placement Papers | Hcl Interview Procedure |
Hcl Aptitude Questions | Hcl Technical Questions
|Hcl Interview Questions

Recently conducted Apptitude test

1966

---

aptitude

1150

---

Do we have vacancy for HR RECRUITER ?

1865

---

A frog wants to climb a pole which is 15 feet in height, frog can jump 3 feet every minute after which he rests for a minute where he slips down 2 feet. How much time will the frog take to reach the top of the pole?

1087

---

What were the occupations of the people who lived within the Mauryan Empire?

1153

---

what is difference between uv and visible spectroscopy and how to differentiate the drug compounds in uv visible region

2127

---

Hi.. Guys Im pranitha, presently im working in a organisation & im look for job at MNC's like DELL, Delloitte, Bank of America, Genpect, etc., I have completed B.com . Pls help me...

1646

---

What are the frequently asked questions for interview in capital iq company ?

1892

---

your project to describe and tell about : 1. My favorite things 2. My favorite places at home 3. Animals *Choose one of them to describe *Write on your paper *If you done, Send me *Did you get it

1287

---

Sks Microfinance

1466

---

my question is : reverse a string in COBOL program (please write a code asap) input file: 1234abcdef output file: 8765_____ abc*$#1___ 1_2_3_4__ cdef____ghi h_k_z_a__ a_z_k_h___ ihg____ghi 4_3_2_1___ 1#$*cba__ ______5678 fedcb4321

1879

---

printf("%d",printf("%d",printf("%d",printf("%s","ILOVECPROGRAM")))); whats the output

1973

---

i want the sample placement paper of goldman sachs urgently. please send it to me

4427

---

what is placement paper?

2661

---

what you will do when you struck in traffic ?

1494

---