28 Answered Questions

[SOLVED] How can I prevent SQL injection in PHP?

11 Answered Questions

[SOLVED] When to use single quotes, double quotes, and back ticks in MySQL

  • 2012-07-04 01:53:36
  • Nate
  • 127595 View
  • 471 Score
  • 11 Answer
  • Tags:   mysql sql quotes

4 Answered Questions

[SOLVED] SQL injection that gets around mysql_real_escape_string()

9 Answered Questions

29 Answered Questions

[SOLVED] SQL select only rows with max value on a column

2 Answered Questions

[SOLVED] Cleansing User Passwords

  • 2016-04-14 16:08:20
  • Jay Blanchard
  • 3765 View
  • 72 Score
  • 2 Answer
  • Tags:   php sql pdo hash

10 Answered Questions

[SOLVED] Select first row in each GROUP BY group?

43 Answered Questions

38 Answered Questions

[SOLVED] Parameterize an SQL IN clause

21 Answered Questions

[SOLVED] Retrieving the last record in each group - MySQL

6 Answered Questions

[SOLVED] SQL Server dynamic PIVOT query?

32 Answered Questions

[SOLVED] What is the difference between "INNER JOIN" and "OUTER JOIN"?

41 Answered Questions

[SOLVED] How do I split a string so I can access item x?

33 Answered Questions

[SOLVED] Fetch the row which has the Max value for a column

13 Answered Questions

[SOLVED] What is SQL injection?

2 Answered Questions

[SOLVED] Efficiently convert rows to columns in sql server

1 Answered Questions

[SOLVED] MySQL pivot row into dynamic number of columns

  • 2012-08-17 11:06:46
  • FeeJai
  • 67570 View
  • 56 Score
  • 1 Answer
  • Tags:   mysql sql pivot

13 Answered Questions

[SOLVED] How to do a FULL OUTER JOIN in MySQL?

13 Answered Questions

[SOLVED] Using LIMIT within GROUP BY to get N results per group?

10 Answered Questions

[SOLVED] INNER JOIN ON vs WHERE clause

6 Answered Questions

[SOLVED] PostgreSQL Crosstab Query

21 Answered Questions

[SOLVED] ROW_NUMBER() in MySQL

11 Answered Questions

[SOLVED] Explicit vs implicit SQL joins

  • 2008-09-04 22:49:58
  • dmanxiii
  • 131071 View
  • 319 Score
  • 11 Answer
  • Tags:   sql join

10 Answered Questions

[SOLVED] Get top n records for each group of grouped results

7 Answered Questions

[SOLVED] What are the options for storing hierarchical data in a relational database?

14 Answered Questions

27 Answered Questions

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

7 Answered Questions

[SOLVED] ORA-00979 not a group by expression

  • 2009-10-05 14:57:21
  • Theresa
  • 281992 View
  • 100 Score
  • 7 Answer
  • Tags:   sql oracle ora-00979

6 Answered Questions

[SOLVED] SQL query return data from multiple tables

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

24 Answered Questions