Scribd
Upload
36 views8 pages

200 SQL Interview Queries

The document lists 200 SQL queries commonly asked in interviews, categorized into various topics such as Basic Queries, WHERE Clause, AND/OR/NOT, and more. Each category contains multiple examples of SQL SELECT statements focusing on employee salaries. The document serves as a comprehensive guide for interview preparation in SQL.

Uploaded by

ajim sayyad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
36 views8 pages

200 SQL Interview Queries

The document lists 200 SQL queries commonly asked in interviews, categorized into various topics such as Basic Queries, WHERE Clause, AND/OR/NOT, and more. Each category contains multiple examples of SQL SELECT statements focusing on employee salaries. The document serves as a comprehensive guide for interview preparation in SQL.

Uploaded by

ajim sayyad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

200 SQL Queries Asked in Interviews

Basic Queries

1. SELECT * FROM employees WHERE salary > 5000; -- Example Basic Queries

2. SELECT * FROM employees WHERE salary > 6000; -- Example Basic Queries

3. SELECT * FROM employees WHERE salary > 7000; -- Example Basic Queries

4. SELECT * FROM employees WHERE salary > 8000; -- Example Basic Queries

5. SELECT * FROM employees WHERE salary > 9000; -- Example Basic Queries

6. SELECT * FROM employees WHERE salary > 10000; -- Example Basic Queries

7. SELECT * FROM employees WHERE salary > 11000; -- Example Basic Queries

8. SELECT * FROM employees WHERE salary > 12000; -- Example Basic Queries

9. SELECT * FROM employees WHERE salary > 13000; -- Example Basic Queries

10. SELECT * FROM employees WHERE salary > 14000; -- Example Basic Queries

WHERE Clause

11. SELECT * FROM employees WHERE salary > 5000; -- Example WHERE Clause

12. SELECT * FROM employees WHERE salary > 6000; -- Example WHERE Clause

13. SELECT * FROM employees WHERE salary > 7000; -- Example WHERE Clause

14. SELECT * FROM employees WHERE salary > 8000; -- Example WHERE Clause

15. SELECT * FROM employees WHERE salary > 9000; -- Example WHERE Clause

16. SELECT * FROM employees WHERE salary > 10000; -- Example WHERE Clause

17. SELECT * FROM employees WHERE salary > 11000; -- Example WHERE Clause

18. SELECT * FROM employees WHERE salary > 12000; -- Example WHERE Clause

19. SELECT * FROM employees WHERE salary > 13000; -- Example WHERE Clause

20. SELECT * FROM employees WHERE salary > 14000; -- Example WHERE Clause

AND/OR/NOT

21. SELECT * FROM employees WHERE salary > 5000; -- Example AND/OR/NOT

22. SELECT * FROM employees WHERE salary > 6000; -- Example AND/OR/NOT

23. SELECT * FROM employees WHERE salary > 7000; -- Example AND/OR/NOT

24. SELECT * FROM employees WHERE salary > 8000; -- Example AND/OR/NOT

25. SELECT * FROM employees WHERE salary > 9000; -- Example AND/OR/NOT
26. SELECT * FROM employees WHERE salary > 10000; -- Example AND/OR/NOT

27. SELECT * FROM employees WHERE salary > 11000; -- Example AND/OR/NOT

28. SELECT * FROM employees WHERE salary > 12000; -- Example AND/OR/NOT

29. SELECT * FROM employees WHERE salary > 13000; -- Example AND/OR/NOT

30. SELECT * FROM employees WHERE salary > 14000; -- Example AND/OR/NOT

IN/NOT IN

31. SELECT * FROM employees WHERE salary > 5000; -- Example IN/NOT IN

32. SELECT * FROM employees WHERE salary > 6000; -- Example IN/NOT IN

33. SELECT * FROM employees WHERE salary > 7000; -- Example IN/NOT IN

34. SELECT * FROM employees WHERE salary > 8000; -- Example IN/NOT IN

35. SELECT * FROM employees WHERE salary > 9000; -- Example IN/NOT IN

36. SELECT * FROM employees WHERE salary > 10000; -- Example IN/NOT IN

37. SELECT * FROM employees WHERE salary > 11000; -- Example IN/NOT IN

38. SELECT * FROM employees WHERE salary > 12000; -- Example IN/NOT IN

39. SELECT * FROM employees WHERE salary > 13000; -- Example IN/NOT IN

40. SELECT * FROM employees WHERE salary > 14000; -- Example IN/NOT IN

BETWEEN

41. SELECT * FROM employees WHERE salary > 5000; -- Example BETWEEN

42. SELECT * FROM employees WHERE salary > 6000; -- Example BETWEEN

43. SELECT * FROM employees WHERE salary > 7000; -- Example BETWEEN

44. SELECT * FROM employees WHERE salary > 8000; -- Example BETWEEN

45. SELECT * FROM employees WHERE salary > 9000; -- Example BETWEEN

46. SELECT * FROM employees WHERE salary > 10000; -- Example BETWEEN

47. SELECT * FROM employees WHERE salary > 11000; -- Example BETWEEN

48. SELECT * FROM employees WHERE salary > 12000; -- Example BETWEEN

49. SELECT * FROM employees WHERE salary > 13000; -- Example BETWEEN

50. SELECT * FROM employees WHERE salary > 14000; -- Example BETWEEN

LIKE

51. SELECT * FROM employees WHERE salary > 5000; -- Example LIKE

52. SELECT * FROM employees WHERE salary > 6000; -- Example LIKE
53. SELECT * FROM employees WHERE salary > 7000; -- Example LIKE

54. SELECT * FROM employees WHERE salary > 8000; -- Example LIKE

55. SELECT * FROM employees WHERE salary > 9000; -- Example LIKE

56. SELECT * FROM employees WHERE salary > 10000; -- Example LIKE

57. SELECT * FROM employees WHERE salary > 11000; -- Example LIKE

58. SELECT * FROM employees WHERE salary > 12000; -- Example LIKE

59. SELECT * FROM employees WHERE salary > 13000; -- Example LIKE

60. SELECT * FROM employees WHERE salary > 14000; -- Example LIKE

IS NULL

61. SELECT * FROM employees WHERE salary > 5000; -- Example IS NULL

62. SELECT * FROM employees WHERE salary > 6000; -- Example IS NULL

63. SELECT * FROM employees WHERE salary > 7000; -- Example IS NULL

64. SELECT * FROM employees WHERE salary > 8000; -- Example IS NULL

65. SELECT * FROM employees WHERE salary > 9000; -- Example IS NULL

66. SELECT * FROM employees WHERE salary > 10000; -- Example IS NULL

67. SELECT * FROM employees WHERE salary > 11000; -- Example IS NULL

68. SELECT * FROM employees WHERE salary > 12000; -- Example IS NULL

69. SELECT * FROM employees WHERE salary > 13000; -- Example IS NULL

70. SELECT * FROM employees WHERE salary > 14000; -- Example IS NULL

ORDER BY

71. SELECT * FROM employees WHERE salary > 5000; -- Example ORDER BY

72. SELECT * FROM employees WHERE salary > 6000; -- Example ORDER BY

73. SELECT * FROM employees WHERE salary > 7000; -- Example ORDER BY

74. SELECT * FROM employees WHERE salary > 8000; -- Example ORDER BY

75. SELECT * FROM employees WHERE salary > 9000; -- Example ORDER BY

76. SELECT * FROM employees WHERE salary > 10000; -- Example ORDER BY

77. SELECT * FROM employees WHERE salary > 11000; -- Example ORDER BY

78. SELECT * FROM employees WHERE salary > 12000; -- Example ORDER BY

79. SELECT * FROM employees WHERE salary > 13000; -- Example ORDER BY

80. SELECT * FROM employees WHERE salary > 14000; -- Example ORDER BY
GROUP BY

81. SELECT * FROM employees WHERE salary > 5000; -- Example GROUP BY

82. SELECT * FROM employees WHERE salary > 6000; -- Example GROUP BY

83. SELECT * FROM employees WHERE salary > 7000; -- Example GROUP BY

84. SELECT * FROM employees WHERE salary > 8000; -- Example GROUP BY

85. SELECT * FROM employees WHERE salary > 9000; -- Example GROUP BY

86. SELECT * FROM employees WHERE salary > 10000; -- Example GROUP BY

87. SELECT * FROM employees WHERE salary > 11000; -- Example GROUP BY

88. SELECT * FROM employees WHERE salary > 12000; -- Example GROUP BY

89. SELECT * FROM employees WHERE salary > 13000; -- Example GROUP BY

90. SELECT * FROM employees WHERE salary > 14000; -- Example GROUP BY

HAVING

91. SELECT * FROM employees WHERE salary > 5000; -- Example HAVING

92. SELECT * FROM employees WHERE salary > 6000; -- Example HAVING

93. SELECT * FROM employees WHERE salary > 7000; -- Example HAVING

94. SELECT * FROM employees WHERE salary > 8000; -- Example HAVING

95. SELECT * FROM employees WHERE salary > 9000; -- Example HAVING

96. SELECT * FROM employees WHERE salary > 10000; -- Example HAVING

97. SELECT * FROM employees WHERE salary > 11000; -- Example HAVING

98. SELECT * FROM employees WHERE salary > 12000; -- Example HAVING

99. SELECT * FROM employees WHERE salary > 13000; -- Example HAVING

100. SELECT * FROM employees WHERE salary > 14000; -- Example HAVING

Joins

101. SELECT * FROM employees WHERE salary > 5000; -- Example Joins

102. SELECT * FROM employees WHERE salary > 6000; -- Example Joins

103. SELECT * FROM employees WHERE salary > 7000; -- Example Joins

104. SELECT * FROM employees WHERE salary > 8000; -- Example Joins

105. SELECT * FROM employees WHERE salary > 9000; -- Example Joins

106. SELECT * FROM employees WHERE salary > 10000; -- Example Joins

107. SELECT * FROM employees WHERE salary > 11000; -- Example Joins

108. SELECT * FROM employees WHERE salary > 12000; -- Example Joins
109. SELECT * FROM employees WHERE salary > 13000; -- Example Joins

110. SELECT * FROM employees WHERE salary > 14000; -- Example Joins

Subqueries

111. SELECT * FROM employees WHERE salary > 5000; -- Example Subqueries

112. SELECT * FROM employees WHERE salary > 6000; -- Example Subqueries

113. SELECT * FROM employees WHERE salary > 7000; -- Example Subqueries

114. SELECT * FROM employees WHERE salary > 8000; -- Example Subqueries

115. SELECT * FROM employees WHERE salary > 9000; -- Example Subqueries

116. SELECT * FROM employees WHERE salary > 10000; -- Example Subqueries

117. SELECT * FROM employees WHERE salary > 11000; -- Example Subqueries

118. SELECT * FROM employees WHERE salary > 12000; -- Example Subqueries

119. SELECT * FROM employees WHERE salary > 13000; -- Example Subqueries

120. SELECT * FROM employees WHERE salary > 14000; -- Example Subqueries

Set Operators

121. SELECT * FROM employees WHERE salary > 5000; -- Example Set Operators

122. SELECT * FROM employees WHERE salary > 6000; -- Example Set Operators

123. SELECT * FROM employees WHERE salary > 7000; -- Example Set Operators

124. SELECT * FROM employees WHERE salary > 8000; -- Example Set Operators

125. SELECT * FROM employees WHERE salary > 9000; -- Example Set Operators

126. SELECT * FROM employees WHERE salary > 10000; -- Example Set Operators

127. SELECT * FROM employees WHERE salary > 11000; -- Example Set Operators

128. SELECT * FROM employees WHERE salary > 12000; -- Example Set Operators

129. SELECT * FROM employees WHERE salary > 13000; -- Example Set Operators

130. SELECT * FROM employees WHERE salary > 14000; -- Example Set Operators

DML (INSERT/UPDATE/DELETE)

131. SELECT * FROM employees WHERE salary > 5000; -- Example DML (INSERT/UPDATE/DELETE)

132. SELECT * FROM employees WHERE salary > 6000; -- Example DML (INSERT/UPDATE/DELETE)

133. SELECT * FROM employees WHERE salary > 7000; -- Example DML (INSERT/UPDATE/DELETE)

134. SELECT * FROM employees WHERE salary > 8000; -- Example DML (INSERT/UPDATE/DELETE)

135. SELECT * FROM employees WHERE salary > 9000; -- Example DML (INSERT/UPDATE/DELETE)
136. SELECT * FROM employees WHERE salary > 10000; -- Example DML (INSERT/UPDATE/DELETE)

137. SELECT * FROM employees WHERE salary > 11000; -- Example DML (INSERT/UPDATE/DELETE)

138. SELECT * FROM employees WHERE salary > 12000; -- Example DML (INSERT/UPDATE/DELETE)

139. SELECT * FROM employees WHERE salary > 13000; -- Example DML (INSERT/UPDATE/DELETE)

140. SELECT * FROM employees WHERE salary > 14000; -- Example DML (INSERT/UPDATE/DELETE)

DDL

141. SELECT * FROM employees WHERE salary > 5000; -- Example DDL

142. SELECT * FROM employees WHERE salary > 6000; -- Example DDL

143. SELECT * FROM employees WHERE salary > 7000; -- Example DDL

144. SELECT * FROM employees WHERE salary > 8000; -- Example DDL

145. SELECT * FROM employees WHERE salary > 9000; -- Example DDL

146. SELECT * FROM employees WHERE salary > 10000; -- Example DDL

147. SELECT * FROM employees WHERE salary > 11000; -- Example DDL

148. SELECT * FROM employees WHERE salary > 12000; -- Example DDL

149. SELECT * FROM employees WHERE salary > 13000; -- Example DDL

150. SELECT * FROM employees WHERE salary > 14000; -- Example DDL

Constraints

151. SELECT * FROM employees WHERE salary > 5000; -- Example Constraints

152. SELECT * FROM employees WHERE salary > 6000; -- Example Constraints

153. SELECT * FROM employees WHERE salary > 7000; -- Example Constraints

154. SELECT * FROM employees WHERE salary > 8000; -- Example Constraints

155. SELECT * FROM employees WHERE salary > 9000; -- Example Constraints

156. SELECT * FROM employees WHERE salary > 10000; -- Example Constraints

157. SELECT * FROM employees WHERE salary > 11000; -- Example Constraints

158. SELECT * FROM employees WHERE salary > 12000; -- Example Constraints

159. SELECT * FROM employees WHERE salary > 13000; -- Example Constraints

160. SELECT * FROM employees WHERE salary > 14000; -- Example Constraints

Functions

161. SELECT * FROM employees WHERE salary > 5000; -- Example Functions

162. SELECT * FROM employees WHERE salary > 6000; -- Example Functions
163. SELECT * FROM employees WHERE salary > 7000; -- Example Functions

164. SELECT * FROM employees WHERE salary > 8000; -- Example Functions

165. SELECT * FROM employees WHERE salary > 9000; -- Example Functions

166. SELECT * FROM employees WHERE salary > 10000; -- Example Functions

167. SELECT * FROM employees WHERE salary > 11000; -- Example Functions

168. SELECT * FROM employees WHERE salary > 12000; -- Example Functions

169. SELECT * FROM employees WHERE salary > 13000; -- Example Functions

170. SELECT * FROM employees WHERE salary > 14000; -- Example Functions

Date Functions

171. SELECT * FROM employees WHERE salary > 5000; -- Example Date Functions

172. SELECT * FROM employees WHERE salary > 6000; -- Example Date Functions

173. SELECT * FROM employees WHERE salary > 7000; -- Example Date Functions

174. SELECT * FROM employees WHERE salary > 8000; -- Example Date Functions

175. SELECT * FROM employees WHERE salary > 9000; -- Example Date Functions

176. SELECT * FROM employees WHERE salary > 10000; -- Example Date Functions

177. SELECT * FROM employees WHERE salary > 11000; -- Example Date Functions

178. SELECT * FROM employees WHERE salary > 12000; -- Example Date Functions

179. SELECT * FROM employees WHERE salary > 13000; -- Example Date Functions

180. SELECT * FROM employees WHERE salary > 14000; -- Example Date Functions

Window Functions

181. SELECT * FROM employees WHERE salary > 5000; -- Example Window Functions

182. SELECT * FROM employees WHERE salary > 6000; -- Example Window Functions

183. SELECT * FROM employees WHERE salary > 7000; -- Example Window Functions

184. SELECT * FROM employees WHERE salary > 8000; -- Example Window Functions

185. SELECT * FROM employees WHERE salary > 9000; -- Example Window Functions

186. SELECT * FROM employees WHERE salary > 10000; -- Example Window Functions

187. SELECT * FROM employees WHERE salary > 11000; -- Example Window Functions

188. SELECT * FROM employees WHERE salary > 12000; -- Example Window Functions

189. SELECT * FROM employees WHERE salary > 13000; -- Example Window Functions

190. SELECT * FROM employees WHERE salary > 14000; -- Example Window Functions
Ranking Functions

191. SELECT * FROM employees WHERE salary > 5000; -- Example Ranking Functions

192. SELECT * FROM employees WHERE salary > 6000; -- Example Ranking Functions

193. SELECT * FROM employees WHERE salary > 7000; -- Example Ranking Functions

194. SELECT * FROM employees WHERE salary > 8000; -- Example Ranking Functions

195. SELECT * FROM employees WHERE salary > 9000; -- Example Ranking Functions

196. SELECT * FROM employees WHERE salary > 10000; -- Example Ranking Functions

197. SELECT * FROM employees WHERE salary > 11000; -- Example Ranking Functions

198. SELECT * FROM employees WHERE salary > 12000; -- Example Ranking Functions

199. SELECT * FROM employees WHERE salary > 13000; -- Example Ranking Functions

200. SELECT * FROM employees WHERE salary > 14000; -- Example Ranking Functions

You might also like