JobsJob TrackerJob alerts

TCS ยท 1,487 questions

All 1,487Coding 601System Design 10Low-Level Design 89Behavioral 288Product Sense 11
  • Final Year Project DiscussionBehavioral
  • Relocation and HomesicknessBehavioral
  • Learning new technologies
  • Disagreement on project approachBehavioral
  • Project purpose and tech stack
  • Technical stack commands and concepts
  • IT Sector and Industry ComparisonBehavioral
  • Handling Conflict, Offers, Rejection, and Leadership StylesBehavioral
  • Purpose of Programming Languages in Real Life
  • How Computers Process Programming Languages
  • Hadoop Architecture and Modern Technologies
  • Indexing, Clustering, and Joins in RDBMS
  • Abstract Classes, Interfaces, and Multiple Inheritance in C++
  • Structure vs Union in C
  • Aggregation vs Composition in Java
  • Java Method and Variable Types
  • DBMS Concepts: Views, ACID, and SQL Commands
  • Measure 4L water with 3L and 5L jugs
  • TCP/IP Protocol Stack
  • Java fundamentals: data types, inheritance, exceptions, and OOPs concepts
  • UNIX commands overview: grep, cat, and tac
  • Career goals, company selection, and long-term commitmentBehavioral
  • Python Data Structures, Pandas, NumPy, and Machine Learning concepts
  • Differences between R and Python for Data Analysis
  • Academic performance gap, service bond, and company expectationsBehavioral
  • AI/ML project architecture and research publication discussionBehavioral
  • Team leadership and managing underperforming teammatesBehavioral
  • Real life example of an Operating System
  • Detailed discussion on final year project and internship experienceBehavioral
  • Technology Selection and JustificationBehavioral
  • Code Snippet Output Analysis
  • Internal Working of HashMaps
  • NLP Project ImplementationBehavioral
  • Project Rationale and MethodologyBehavioral
  • Core CS Concepts and Inheritance
  • OOP Implementation Pseudocode
  • Study Gap and ProductivityBehavioral
  • Big Data and MapReduce ConceptsBehavioral
  • Stack and Queue Fundamentals
  • Database Tables, Indexes, and Joins
  • SDLC and Testing Types
  • Print all permutationsCoding
  • Print pyramid patternCoding
  • Modified Kadane's Algorithm for rangeCoding
  • HR Confidence and Leadership CheckBehavioral
  • Hackathon Experience and AchievementsBehavioral
  • Career Goals and Leadership SkillsBehavioral
  • Supervised, Unsupervised Learning and RegressionProduct Sense
  • Cloud Architecture and Mobile ComputingLow-Level Design
  • Blockchain and Smart ContractsLow-Level Design
  • Storage Classes in CLow-Level Design
  • SQL Queries for Unique and Duplicate MarksLow-Level Design
  • Lambda Function in PythonLow-Level Design
  • Explain the MERN tech stack.
  • Why do we need Express.js if Node.js exists?
  • Can I run two Node.js projects with different versions?
  • What is the purpose of the .env file?
  • How are applications rendered and deployed?
  • What are RESTful APIs and can POST be replaced by PUT?
  • MongoDB CLI and NoSQL vs SQL
  • Explain APIs and difference between GET and POST
  • Design a database for a college.Low-Level Design
  • Explain the software life cycle.
  • Comfort with shift workBehavioral
  • Technical knowledge check
  • TCP vs UDP
  • OOPs concepts and volatile keyword
  • Android and Web development
  • Pointers and Data Structures
  • Parent-to-Child and SOSL Queries
  • HR QuestionsBehavioral
  • Non-Technical and HR AssessmentBehavioral
  • What is a deadlock?
  • Windows 11 features
  • Knowledge of R-Programming
  • Project investment pitch
  • Cloud technology impact
  • Most important achievementBehavioral
  • Career and offer statusBehavioral
  • Cybersecurity and Java conceptsLow-Level Design
  • Polymorphism, Abstraction, and Python arguments
  • Hadoop and Hive Queries
  • OOP, Exception handling and string reverse codeLow-Level Design
  • Python range vs xrange and OOPs real-world examples
  • React components, re-rendering, and web concepts
  • Explain differences between C and C++ and inheritance examplesLow-Level Design
  • Multidisciplinary technical and core engineering questions
  • Real-Time Operating Systems (RTOS)
  • Strengths, Weaknesses, and Career GoalsBehavioral
  • Multiply matrices, nth prime, reverse string & SQL/HTML tasksCoding
  • DBMS, OOPs, OS and Networking questions
  • MATLAB basics
  • Handling project deadlines and unknown tasksBehavioral
  • Management round questionsBehavioral
  • Technical round questions
  • AWS Concepts
  • Aptitude and Puzzles
  • SQL query based on project
  • SDLC phases
  • Team conflict scenariosBehavioral
โ† TCS questions
  1. Interview questions
  2. TCS
  3. SQL query based on project

SQL query based on project

Filed under TCS

The question

Write a SQL query related to the project scenario.

No write-up yet. Related questions below have one.

Related TCS questions

  • Palindrome check
  • Check if a number is Prime or not
  • Star pattern printing
  • Check Armstrong Number
  • Sort array by parity conditions
โ† Aptitude and PuzzlesSDLC phases โ†’

Collected from public candidate posts and coding forums. Updated Nov 2026.