hi i want to write that query. i have oil lots of oil tank. some times our system can not be define underde the 13 cm how many liter do we have. so i need when product level equal to 0's one record before. sory my english is not good.
where ProcessTime >='20121101' and ProcessTime<'20121201' and ProductLevel ( the last record without the need to level 0)
I'm not sure I understand how to express the predicate from what you wrote. Can you provide DDL, DML and expected output? Here are some links that can help with that:
hi i want to write that query. i have oil lots of oil tank. some times our system can not be define underde the 13 cm how many liter do we have. so i need when product level equal to 0's one record before. sory my english is not good.
where ProcessTime >='20121101' and ProcessTime<'20121201' and ProductLevel ( the last record without the need to level 0)
How do determine the order of the rows to determine the "last" row?
It's very hard for us to help withoyt knowing your data. Please, follow the links I provided and post the proper information for us to be able to help you better.
How do determine the order of the rows to determine the "last" row?
It's very hard for us to help withoyt knowing your data. Please, follow the links I provided and post the proper information for us to be able to help you better.
if productlevel equal to 0, maybe we can get before the 0 record.
Write your question clearly and with as much detail as possible in Turkish. Then translate it to English using http://translate.google.com and post the translated version. With what you have posted so far, it has not been possible to understand the problem.
Also, look at the two links Lamprey posted (translate them to Turkish using http://translate.google.com if you have to). Those will help write your question in a form others can understand.
before one record
Posted - 11/28/2012 : 11:59:19
