SQL question Remove duplicate from a table tab1
AnswerBot
8mo
Use the DISTINCT keyword in SQL to remove duplicates from a table.
Use the SELECT DISTINCT statement to retrieve unique rows from the table.
Identify the columns that should be used to determine uniquen...read more
Anonymous
author
9mo
Select id, name, salary from (Select id, name, salary, count(*) from tab1
Group by id, name, salary ) x
Help your peers!
Add answer anonymously...
Top Nielsen Data Scientist interview questions & answers
Popular interview questions of Data Scientist
Top HR questions asked in Nielsen Data Scientist
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
