가장 많이 묻는 면접 질문과 답변 & 온라인 테스트
면접 준비, 온라인 테스트, 튜토리얼, 라이브 연습을 위한 학습 플랫폼

집중 학습 경로, 모의고사, 면접 준비 콘텐츠로 실력을 키우세요.

WithoutBook은 주제별 면접 질문, 온라인 연습 테스트, 튜토리얼, 비교 가이드를 하나의 반응형 학습 공간으로 제공합니다.

라이브러리 검색
Prepare Interview

SQL Query 면접 질문과 답변

Ques 21. Explain the difference between a primary key and a unique key.

A primary key is used to uniquely identify each record in a table and cannot contain NULL values. A unique key enforces uniqueness but can contain NULL values.

도움이 되었나요? Add Comment View Comments
 

Ques 22. Write a SQL query to find the nth highest salary from an Employee table.

SELECT salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET n-1;

도움이 되었나요? Add Comment View Comments
 

Ques 23. Explain the difference between UNION and JOIN.

UNION is used to combine the results of two or more SELECT statements, while JOIN is used to retrieve data from multiple tables based on a related column between them.

도움이 되었나요? Add Comment View Comments
 

Ques 24. What is a trigger in SQL?

A trigger is a set of instructions that are automatically executed (or 'triggered') in response to certain events on a particular table or view.

도움이 되었나요? Add Comment View Comments
 

Ques 25. Write a SQL query to update multiple rows in a table.

UPDATE table SET column1 = value1, column2 = value2 WHERE condition;

도움이 되었나요? Add Comment View Comments
 

Most helpful rated by users:

Copyright © 2026, WithoutBook.