Can anyone help me to do this :
Select previous field based on previous field in sql. I had tried a lot of ways but it seems doesn't works.
Select alert_value , year_id from company_alert where year_id = "2010" and year_id = year_id - 1 group by year_id
could anyone help me on how to do this :(