select id from p4_versions where (versionof, version) = (select id, headver from p4_files where p4path like '%/date.txt');
Thursday, April 27, 2006
Oracle: row-wise comparison
I had a query that needed to compare two columns in a row andwas making two queries to do so. All hail the row-wise comparison!
Subscribe to:
Posts (Atom)
-
A while back I answered a question on Stack Overflow asking about the relative popularity of The Art of Computer Programming . I replied wit...
-
I learned a lot from Laurens Kuiper's blog post Testing out DuckDB's Full Text Search Extension , but unfortunately couldn't fin...
-
First, let's draw a cube: cube(10,true); Now, let's animate a 360 degree turntable view of the cube: rotate([0,0,$...