-
as seen on Stack Overflow
- Search for 'Stack Overflow'
What I essentially want, is to retreive all features and values of products which have a particular feature and value.
For example: I want to know all available hard drive sizes of products that have an Intel processor.
I have three tables:
product_to_value (product_id, feature_id, value_id)
features…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi All,
I'm trying to work out a query that self join itself on a table using the eventnumber. I've never done a self join before.
What i'm trying to query is when a client has started off in a city which is chester to see what city they moved to. But I dont want to be able to see if they started…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Well as you may know, you cannot index a view with a self join. Well actually even two joins of the same table, even if it's not technically a self join. A couple of guys from microsoft came up with a work around. But it's so complicated I don't understand it!!!
The solution to the problem is here:…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
When I write the following class, I get the following compilation error:
could not resolve property
How can I achive the following:
class Employee{
String Name
String Email
Employee Manager
static hasMany = [desginations:Designation]
static constraints = {
Name(unique:true)
…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi
Any ideas how i go about replacing the following self join using analytics
SELECT
t1.col1 col1,
t1.col2 col2,
SUM((extract(hour FROM (t1.times_stamp - t2.times_stamp)) * 3600 + extract(minute FROM ( t1.times_stamp - t2.times_stamp)) * 60 + extract(second FROM ( t1.times_stamp - t2.times_stamp))…
>>> More
