SQL Second-Highest Credit Limit | Dataford Interview Questions

Write a SQL query to find the second-highest credit limit within a specific customer segment.

Use the customers and credit_accounts tables and filter for the Prime segment. Treat the second-highest value as the second distinct credit limit, and include all customers tied at that value.

Output

One row per qualifying customer account with customer_id, customer_name, and credit_limit.
Include only Prime customers at the second-highest non-null credit limit.
Order by credit_limit descending, then customer_id ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer full name
segment	VARCHAR(30)	Customer segment

credit_accounts

Column	Type	Description
account_idPK	INT	Unique credit account identifier
customer_id	INT	Customer associated with the account
account_type	VARCHAR(40)	Type of credit account
credit_limit	DECIMAL(12,2)	Approved credit limit

Your question is SQL Second-Highest Credit Limit. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem