What is wrong with this SQL query? Correct it so it executes properly. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
- 1

What is wrong with this SQL query? Correct it so it executes properly.

SELECT Id, YEAR(BillingDate) AS BillingYear FROM Invoices WHERE BillingYear >= 2010;

21st Dec 2016, 5:20 AM
Akwin Lopez
Akwin Lopez - avatar
2 Answers
0
SELECT Id, YEAR(BillingDate) AS BillingYear FROM Invoices WHERE YEAR( BillingDate) >= 2010;
21st Dec 2016, 5:28 AM
Akwin Lopez
Akwin Lopez - avatar
0
whawt??
21st Dec 2016, 6:09 AM
manish rawat
manish rawat - avatar