You see a screenshot of sorted data by device_id and ts_start (timestamp when session started). I need to run a search that will SELECT only rows where device_id is same but the first row has licence type 0 and second row licence type 1 when comparing. This would result in device_id that upgraded from 0 to 1.
Then just alter the code, so I can look for downgrades, meaning where in the first row licence is 1 and then 0.
33 freelancers are bidding on average $6/hour for this job
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
I value trust the most. No need to speak much. Project will show all. I wish we talk more about the project during interview. Please suggest suitable time to discuss seriously. Sincerely.
select t1.device_id, [login to view URL] from table1 t1 inner join (select device_id from table1 group by device_id having count(device_id)>1 ) t2 on t1.device_id=t2.device_id order by t1.device_id, [login to view URL] desc
I have 20 years of experience in dev app on oracle CS degree 25 oracle certified trainings I will create these data on my database and send you the query for desired output
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7 years and 8 months experience in SQL. Please let me know more details and when we will start. Sky pe jikenjd
Yes, you're right: it is 5 dollars job :) I'm free today and can do this for you in minutes. Could you please tell me at least the table name for the query and list of columns or this table? Sincerely, Sergii
let me know how the ts_start value is calculated and what is the order (sort) of ts_start attribute. Then its simple to write query to find downgraded and upgraded devices.