28 Answered Questions

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

12 Answered Questions

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

  • 2012-07-04 01:53:36
  • Nate
  • 197605 View
  • 632 Score
  • 12 Answer
  • Tags:   mysql sql quotes

4 Answered Questions

[SOLVED] SQL injection that gets around mysql_real_escape_string()

27 Answered Questions

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

10 Answered Questions

16 Answered Questions

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

27 Answered Questions

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

2 Answered Questions

[SOLVED] Cleansing User Passwords

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

7 Answered Questions

[SOLVED] SQL Server dynamic PIVOT query?

47 Answered Questions

40 Answered Questions

[SOLVED] Parameterize an SQL IN clause

26 Answered Questions

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

15 Answered Questions

[SOLVED] How to create a MySQL hierarchical recursive query

35 Answered Questions

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

44 Answered Questions

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

9 Answered Questions

[SOLVED] What is SQL injection?

1 Answered Questions

[SOLVED] MySQL pivot row into dynamic number of columns

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

2 Answered Questions

[SOLVED] Efficiently convert rows to columns in sql server

14 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?

8 Answered Questions

[SOLVED] Convert Rows to columns using 'Pivot' in SQL Server

7 Answered Questions

[SOLVED] Why do we always prefer using parameters in SQL statements?

24 Answered Questions

[SOLVED] ROW_NUMBER() in MySQL

7 Answered Questions

11 Answered Questions

[SOLVED] INNER JOIN ON vs WHERE clause

6 Answered Questions

[SOLVED] PostgreSQL Crosstab Query

12 Answered Questions

[SOLVED] Explicit vs implicit SQL joins

  • 2008-09-04 22:49:58
  • dmanxiii
  • 166877 View
  • 395 Score
  • 12 Answer
  • Tags:   sql join

10 Answered Questions

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

3 Answered Questions

11 Answered Questions

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