JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
Real questions from top companies
Write a query to get the latest rule_id and rule_status.
Write a query to get the names of all employees who are managers with five or more direct reports.
Write a query to identify duplicate customer entries based on email and phone number.
Write a query to identify unique user sessions.
Write a query to remove duplicate records from a table while retaining the earliest entry.
Write a query to retain only the latest record and delete others in case of duplicates.
Write a query to select the latest record based on a time_of_insertion column.
Write a query to switch values in the Gender column (M to F and F to M).
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.