- 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 ответов
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