Reputation
36,922
Next tag badge:
484/1000 score
132/200 answers
Badges
7 61 118
Newest
 Enlightened
Impact
~1.9m people reached

7h
reviewed No Action Needed couchbase - multiple buckets or documents with different types
7h
reviewed Reviewed Query tables in a tablespace to find the physical location of extents?
7h
comment How to configure restful api services with java on a xampp local server
Too broad and off-topic.
7h
reviewed Close How to configure restful api services with java on a xampp local server
10h
comment Need help improving sql query performance
<> SELECT MAX (DATE ('created at') FROM 't2') is not valid syntax. Perhaps you meant: <> (SELECT MAX(DATE(created at)) FROM t2)
12h
comment Outer self join filters vs subqueries
Yes on the first. On the second problem, if there is a ticket that is 'sold' and then (say) 'returned' (but not a row with 'used') then this ticket will be shown in the results of the first query (as "sold" but not "used") but it will NOT be shown in the results of the second query. So, it depends on what the OP wants the results to be.
14h
reviewed Close which database to use with FileNet
14h
reviewed Close MySQL Server won't start
14h
reviewed Close Special Characters from DB2 database are getting distorted in Java
14h
reviewed Close transfer the new posts on local to host
14h
reviewed Reviewed Normalized college database desgin
14h
revised Normalized college database desgin
added 62 characters in body
14h
reviewed Reviewed VMware vFabric Data Director
14h
comment Need help improving sql query performance
The ORDER BY is not always a problem. It might be worth checking but there are many other things worth checking in the query. The ORDER BY DATE(column) is probably one reason - of the many - for the slow query.
14h
comment Need help improving sql query performance
What's the use of (price > -1 OR price <> 999999.99) condition which appears twice? Seems useless.
1d
awarded  Enlightened
1d
awarded  Nice Answer
1d
comment ON DELETE CASCADE doesn't work even storage table is InnoDb
@Vérace I don't delete records because my tables have only rows ;)
1d
answered ON DELETE CASCADE doesn't work even storage table is InnoDb
1d
comment Outer self join filters vs subqueries
The second query is not 100% equivalent to the first, in 2 cases. 1, if TransType is nullable and 2 if TransType can have other values besides 'used' and 'sold'.