[sql-function] Forum Topics

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 …

This is old college assignment am doing to sharpen my sql skills, its cat test centre and this funtion is checking if the mechanic is available on certain date which is input from user in the anonymous block. the problem i m having durning testing is that the function result …