Asked in Cognizant
Given two tables, one with 20 student records and another with 10, how would you retrieve the common records between them?
AnswerBot
1y
Use SQL JOIN to fetch common records from two tables.
Use SQL JOIN to combine the two tables based on a common column (e.g. student ID).
Select the columns you want to retrieve from both tables.
Use the ...read more
Help your peers!
Add answer anonymously...
Top Programmer Analyst Interview Questions Asked at Cognizant
Q. What are the concepts of OOPS?
Q. What is a window function in SQL?
Q. What is the difference between partition and cluster?
Interview Questions Asked to Programmer Analyst at Other Companies
Top Skill-Based Questions for Cognizant Programmer Analyst
Data Structures Interview Questions and Answers
250 Questions
Algorithms Interview Questions and Answers
250 Questions
Java Interview Questions and Answers
250 Questions
SQL Interview Questions and Answers
250 Questions
Web Development Interview Questions and Answers
250 Questions
C++ Interview Questions and Answers
150 Questions
Stay ahead in your career. Get AmbitionBox app
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
Follow Us
