[sql-where] Forum Topics

In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: …

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. [CODE]Select alert_value , year_id from company_alert where year_id = "2010" and year_id = year_id - 1 group by year_id[/CODE] could anyone …