CareerCup

Adobe Interview Question Software Engineer in Tests

  • adobe-interview-questions
    0
    of 0 votes
    17
    Answers

    You have a database table Emp with data as follows:

    EmpId FirstName LastName
    1 Bob Lync
    2 Sarah John
    3 Bob Lync
    4 John Doe
    5 Stanly Jeff
    6 Sarah John

    With a single sql query, how will you cleanup the database (eliminate redundant data from above table)

    - matrix on July 31, 2012 in United States Report Duplicate | Flag
    Adobe Software Engineer in Test Database

Country: United States
More Questions from This Interview

Comment hidden because of low score. Click to expand.
9
of 9 vote

delete from employee where rowid not in (select min(rowid) from employee group by firstName , lastName)

- entityvsentityv2 on August 02, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 votes

it will delete all duplicated instance..

- nikhilranjan234 on August 14, 2012 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 votes

Query is fine.. Nikhil... Hw can it deletes all duplicates ??

- dildileepkumar on October 06, 2012 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 votes

absolutely correct query cause for each insert there would be unique index generated no mattr insertion is repeated or not. In answer d query is deleting the duplicate indices using Not in.

- swapnil on January 06, 2013 | Flag
Comment hidden because of low score. Click to expand.
3
of 3 vote

delete from Emp where Emp.EmpId IN (select EmpId from Emp Emp2 where Emp.FirstName = Emp2.FirstName and Emp.LastName = Emp2.LastName and Emp2.EmpId <> Emp.EmpId)

- Elijah on July 31, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 votes

Won't this delete every instance of duplicated data?

Perhaps we should do Emp2.EmpId > Emp.EmpId, rather than <>.

- Anonymous on August 01, 2012 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 votes

Yeh this will delete all duplicate values

- Hoper on October 11, 2012 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 vote

ALTER IGNORE TABLE emp ADD UNIQUE INDEX(first,last)

- woggle on August 20, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

delete from employee where employeeId in 
(
select top 2 employeeid from employee where 
employeename in (select employeeName from employee group by employeeName having count(*) > 1) order by employeeId desc)

- Niraj on November 30, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

use CTE

- ayangyang on June 02, 2013 | Flag Reply
Comment hidden because of low score. Click to expand.
-1
of 1 vote

Select emp id, first name, last name, count (*) from EMP
Group by first name, last name
where count(*) > 1

this will return the duplicate records and Delete it using delete query....

- Gyanendra prasad Giri on September 02, 2012 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 votes

This query wont work - the group by clause wont let you have the emp id in the select clause, as you are aggregating on first and last names.

- Makarand on May 30, 2013 | Flag
Comment hidden because of low score. Click to expand.
Comment hidden because of low score. Click to expand.
Comment hidden because of low score. Click to expand.
Comment hidden because of low score. Click to expand.
1
of 1 vote

This code works fine for me. have used Common Table expressions .

WITH CTE_1
AS (
SELECT first_name, last_name, ROW_NUMBER() OVER (ORDER BY first_name,last_name) AS keep_ID ,
DENSE_RANK() OVER(ORDER BY first_name,last_name) AS RANK FROM persons_cup)
DELETE FROM CTE_1 WHERE keep_ID NOT IN
(SELECT MIN(keep_id) FROM CTE_1 B GROUP BY RANK)

- Nilesh.K.Molankar on October 15, 2012 | Flag
Comment hidden because of low score. Click to expand.
0
of 0 votes

This one works !!

- Vishal on December 31, 2012 | Flag


Add a Comment
Name:

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.

Books

is a comprehensive book walking you through every aspect of getting a job at a top tech company, while focuses on software engineering interviews.

Learn More

Videos

CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More