34 Answered Questions

[SOLVED] How do I UPDATE from a SELECT in SQL Server?

18 Answered Questions

4 Answered Questions

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

14 Answered Questions

10 Answered Questions

[SOLVED] How to include a PHP variable inside a MySQL statement

29 Answered Questions

14 Answered Questions

[SOLVED] Update statement with inner join on Oracle

15 Answered Questions

[SOLVED] Calculate a Running Total in SQL Server

26 Answered Questions

[SOLVED] T-SQL split string

10 Answered Questions

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

11 Answered Questions

[SOLVED] Rank function in MySQL

  • 2010-07-26 09:35:48
  • Aadi
  • 258801 View
  • 155 Score
  • 11 Answer
  • Tags:   mysql sql rank

18 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
  • 402289 View
  • 146 Score
  • 8 Answer
  • Tags:   sql oracle ora-00979

15 Answered Questions

[SOLVED] Why is SELECT * considered harmful?

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

16 Answered Questions

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

6 Answered Questions

[SOLVED] SQL query return data from multiple tables

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

12 Answered Questions

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

25 Answered Questions

[SOLVED] Remove duplicate rows in MySQL

  • 2010-07-22 18:03:56
  • Chetan
  • 372906 View
  • 375 Score
  • 25 Answer
  • Tags:   mysql sql duplicates

10 Answered Questions

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

18 Answered Questions

[SOLVED] Join vs. sub-query

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

17 Answered Questions

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

11 Answered Questions

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

6 Answered Questions

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

25 Answered Questions

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

  • 2010-12-01 21:35:14
  • Francisc
  • 452350 View
  • 463 Score
  • 25 Answer
  • Tags:   mysql sql

16 Answered Questions

[SOLVED] Insert, on duplicate update in PostgreSQL?

29 Answered Questions

[SOLVED] Fastest Way of Inserting in Entity Framework

16 Answered Questions

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

13 Answered Questions

9 Answered Questions