17 Answered Questions

14 Answered Questions

25 Answered Questions

8 Answered Questions

[SOLVED] ORA-00979 not a group by expression

  • 2009-10-05 14:57:21
  • Theresa
  • 332438 View
  • 121 Score
  • 8 Answer
  • Tags:   sql oracle ora-00979

10 Answered Questions

[SOLVED] Can I concatenate multiple MySQL rows into one field?

3 Answered Questions

10 Answered Questions

[SOLVED] MySQL - Rows to Columns

9 Answered Questions

[SOLVED] How to 'insert if not exists' in MySQL?

6 Answered Questions

[SOLVED] SQL query return data from multiple tables

  • 2012-09-18 11:11:39
  • Fluffeh
  • 730903 View
  • 407 Score
  • 6 Answer
  • Tags:   mysql sql select

16 Answered Questions

14 Answered Questions

[SOLVED] Update statement with inner join on Oracle

10 Answered Questions

[SOLVED] Rank function in MySQL

  • 2010-07-26 09:35:48
  • abhis
  • 217581 View
  • 141 Score
  • 10 Answer
  • Tags:   mysql sql rank

9 Answered Questions

[SOLVED] How do I obtain a Query Execution Plan?

25 Answered Questions

[SOLVED] T-SQL split string

15 Answered Questions

[SOLVED] Why is SELECT * considered harmful?

  • 2010-09-03 22:02:25
  • Theodore R. Smith
  • 62404 View
  • 215 Score
  • 15 Answer
  • Tags:   sql database

6 Answered Questions

[SOLVED] How do I create a parameterized SQL query? Why Should I?

5 Answered Questions

[SOLVED] What are good ways to prevent SQL injection?

17 Answered Questions

[SOLVED] Join vs. sub-query

  • 2010-04-05 06:22:22
  • Your Common Sense
  • 361253 View
  • 696 Score
  • 17 Answer
  • Tags:   sql mysql subquery join

19 Answered Questions

[SOLVED] Remove duplicate rows in MySQL

  • 2010-07-22 18:03:56
  • Chetan
  • 327219 View
  • 319 Score
  • 19 Answer
  • Tags:   mysql sql duplicates

10 Answered Questions

[SOLVED] How to apply bindValue method in LIMIT clause?

16 Answered Questions

[SOLVED] Insert, on duplicate update in PostgreSQL?

10 Answered Questions

[SOLVED] Insert into a MySQL table or update if exists

23 Answered Questions

[SOLVED] MySQL select 10 random rows from 600K rows fast

13 Answered Questions

16 Answered Questions

[SOLVED] How to create id with AUTO_INCREMENT on Oracle?

12 Answered Questions

[SOLVED] Count(*) vs Count(1) - SQL Server

27 Answered Questions

[SOLVED] Fastest Way of Inserting in Entity Framework

14 Answered Questions

[SOLVED] How do I limit the number of rows returned by an Oracle query after ordering?

15 Answered Questions

[SOLVED] Error related to only_full_group_by when executing a query in MySql

7 Answered Questions

[SOLVED] How can you represent inheritance in a database?