Intermediate SQL interview questions with detailed answers: 11. Find Customer Order Counts Question: Write a query to list customers who have placed more than 5 orders. Use the customers and orders tables. Answer: SELECT c.customer_id, c.customer_name, COUNT(o.order_id) AS order_count FROM ...
SQL Interview Questions and Answers Top 35 Database Testing Interview Questions and Answers How to Find the Second Highest Salary in SQL ByAkshay|Last updated on October 3, 2024|55416 Views Did You Know? PL/SQLcode can include comments inside it starting with /* and ending with */ like in...
1 answer One of the answers was accepted by the question author. Git Automation with SQL Tools and Visual Studio Code So here's my situation: We have a database application created and maintained by a third party We have access to the application to debug/extend that application to meet ...
1 answer One of the answers was accepted by the question author. Splitting record data dependent on other table data Hi, Hoping for some assistance. I have a table which holds how much consumer owe in two different buckets and there is another table where the transactions are held. I need...
edited the question Dec 23, 2024, 11:14 PM TP 100.9K Reputation points 2 answers How to expand my db for more markets ? Right now SQL server db is running in one region and right now we have enabled solution for one market, in future we need to roll out for more markets and ...
edited the question Jan 4, 2025, 5:59 AM Erland Sommarskog 114.8K Reputation points • MVP 2 answers SQL Server 2022 Developer Edition failing install with error code -2068052310 I'm trying to install SQL Server 2022 Developer Edition and am getting an error stating that an installatio...
In order to have a table to demonstrate using the CASE expression I will be using the script in Listing 1 to create a sample table namedMyOrder. If you would like to follow along with my examples and run them on your SQL Server instance you can create this table in a database of you...
Setup and Usage Where can SQLHC be downloaded from? How can I identify the SQL I want to Healthcheck? Does SQLHC have to execute the SQL to generate a report? What if the SQL_ID in question has been aged out from memory? Can SQLHC retrieve an explain plan from memory or the AWR?
2 Answers Sorted by: 1 Let's use your example.. car: car_id name wheel: wheel_id car_id If your first question is asking if you should ensure that there is a corresponding row in the car table when you insert a record into the wheel table, then yes! In reality...
A Microsoft platform for building enterprise-level data integration and data transformations solutions. 2,644 questions Sign in to follow asked Jan 31, 2025, 9:53 PM Anil 40 Reputation points edited the question Feb 5, 2025, 9:22 AM ZoeHui-MSFT 40,511 Reputation points 2 answers ...