I have been in touch with IBM DB2 recently. And some of the features can be really awesome, such as complex type support. My question is, in my short 3 years career I have seen this in any of my work place. So, assuming it is not that widely used, wh...
Join discussionI am using PostgreSQL DB. I need to create a view which comprises of a query with joins on multiple tables but I am stuck at a point. Please read the below table definition and the Query which I have created. Tables: Students --------- id -> UUID fu...
Join discussionBackground: I work on a small team of around seven developers and DB architects. I'm a mid-level developer at the company, but started as a trainee as a summer job which led to a junior developer position as my first real job in tech. Our tech stack ...
OMJAustin and 2 more commentedI am getting this error PG::GroupingError when I try to run this query Interaction. order('interactions.created_at DESC'). joins({candidate: [:job,{application: :user}]}). group('interactions.candidate_id') What I'm trying to do is to group ...
Join discussion