14 Answered Questions

3 Answered Questions

27 Answered Questions

15 Answered Questions

[SOLVED] Calculate a Running Total in SQL Server

11 Answered Questions

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

16 Answered Questions

12 Answered Questions

[SOLVED] MySQL - Rows to Columns

8 Answered Questions

[SOLVED] ORA-00979 not a group by expression

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

9 Answered Questions

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

25 Answered Questions

[SOLVED] T-SQL split string

6 Answered Questions

[SOLVED] SQL query return data from multiple tables

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

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
  • Aadi
  • 233561 View
  • 145 Score
  • 10 Answer
  • Tags:   mysql sql rank

4 Answered Questions

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

10 Answered Questions

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

7 Answered Questions

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

16 Answered Questions

[SOLVED] Why is SELECT * considered harmful?

  • 2010-09-03 22:02:25
  • Theodore R. Smith
  • 68309 View
  • 226 Score
  • 16 Answer
  • Tags:   sql database

23 Answered Questions

[SOLVED] Remove duplicate rows in MySQL

  • 2010-07-22 18:03:56
  • Chetan
  • 342266 View
  • 342 Score
  • 23 Answer
  • Tags:   mysql sql duplicates

18 Answered Questions

[SOLVED] Join vs. sub-query

  • 2010-04-05 06:22:22
  • Your Common Sense
  • 388625 View
  • 751 Score
  • 18 Answer
  • Tags:   sql mysql subquery join

6 Answered Questions

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

10 Answered Questions

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

11 Answered Questions

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

16 Answered Questions

[SOLVED] Insert, on duplicate update in PostgreSQL?

24 Answered Questions

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

  • 2010-12-01 21:35:14
  • Francisc
  • 423090 View
  • 432 Score
  • 24 Answer
  • Tags:   mysql sql

13 Answered Questions

28 Answered Questions

[SOLVED] Fastest Way of Inserting in Entity Framework

16 Answered Questions

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

16 Answered Questions

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

12 Answered Questions

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

15 Answered Questions

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