Hcl Technologies 3+ Experienced Sql server Questions
- 20 Answers
- 53026 Views
- HCL, Patni, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 36 Yes | 4 No |
Post New Answer View All Answers
Do we have vacancy for HR RECRUITER ?
how did you celebrate your last birthday?
What kind of Issues/bugs arise in ETL projects? I would like to know few issues (critical to somewhat bugs ) normally occur in ETL process especially when testing? Domains can be banking, retail or any.
If anybody knows the recruitment procedure of IOTL & POWER MECHANICAL. send me the placement papers if u hav... very urgent ...
i want the sample placement paper of goldman sachs urgently. please send it to me
What were the occupations of the people who lived within the Mauryan Empire?
email me previous question papers of bob bank for po exams
printf("%d",printf("%d",printf("%d",printf("%s","ILOVECPROGRAM")))); whats the output
what is difference between uv and visible spectroscopy and how to differentiate the drug compounds in uv visible region
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
why didn't get placed so far?
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...
What are the frequently asked questions for interview in capital iq company ?
Sks Microfinance
what is bidirectional?
