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
  • 171379 View
  • 589 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

2 Answered Questions

[SOLVED] Cleansing User Passwords

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

14 Answered Questions

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

46 Answered Questions

25 Answered Questions

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

7 Answered Questions

[SOLVED] SQL Server dynamic PIVOT query?

40 Answered Questions

[SOLVED] Parameterize an SQL IN clause

24 Answered Questions

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

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
  • 82444 View
  • 73 Score
  • 1 Answer
  • Tags:   mysql sql pivot

34 Answered Questions

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

15 Answered Questions

[SOLVED] How to create a MySQL hierarchical recursive query

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

11 Answered Questions

[SOLVED] INNER JOIN ON vs WHERE clause

6 Answered Questions

[SOLVED] PostgreSQL Crosstab Query

23 Answered Questions

[SOLVED] ROW_NUMBER() in MySQL

12 Answered Questions

[SOLVED] Explicit vs implicit SQL joins

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

7 Answered Questions

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

10 Answered Questions

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

17 Answered Questions

33 Answered Questions

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