Alex Rivera | Logout

Questions tagged ansi-sql

7 questions

Sort by: Newest Votes Active
22
votes
4
answers

SQL query with distinct and sum

sql sum distinct ansi-sql
asked 2013-03-19T23:43:01.543
59
votes
8
answers

In MySQL, should I quote numbers or not?

mysql sql ansi-sql
asked 2011-07-21T19:58:40.333
12
votes
4
answers

Standard SQL alternative to Oracle DECODE

sql oracle-database ansi-sql
asked 2010-07-09T11:15:11.843
23
votes
4
answers

Why do I need to explicitly specify all columns in a SQL "GROUP BY" clause - why not "GROUP BY *"?

group-by aggregate ansi-sql sql
asked 2010-05-05T22:33:14.723
75
votes
6
answers

Why does MySQL allow "group by" queries WITHOUT aggregate functions?

mysql sql standards-compliance ansi-sql
asked 2009-08-03T23:44:57.177
40
votes
7
answers

Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?

mysql database keyword ansi-sql
asked 2009-02-27T15:04:26.940
13
votes
9
answers

There are a method to paging using ANSI SQL only?

sql ansi-sql
asked 2009-01-21T01:42:29.130