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
  • 118364 View
  • 438 Score
  • 11 Answer
  • Tags:   mysql sql quotes

5 Answered Questions

[SOLVED] SQL injection that gets around mysql_real_escape_string()

9 Answered Questions

2 Answered Questions

[SOLVED] Cleansing User Passwords

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

29 Answered Questions

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

9 Answered Questions

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

41 Answered Questions

38 Answered Questions

[SOLVED] Parameterize an SQL IN clause

18 Answered Questions

[SOLVED] Retrieving the last record in each group

6 Answered Questions

[SOLVED] SQL Server dynamic PIVOT query?

33 Answered Questions

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

39 Answered Questions

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

  • 2008-08-05 18:15:47
  • GateKiller
  • 737323 View
  • 433 Score
  • 39 Answer
  • Tags:   sql sql-server split

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

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?

1 Answered Questions

[SOLVED] MySQL pivot row into dynamic number of columns

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

10 Answered Questions

[SOLVED] INNER JOIN ON vs WHERE clause

11 Answered Questions

[SOLVED] Explicit vs implicit SQL joins

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

5 Answered Questions

[SOLVED] PostgreSQL Crosstab Query

20 Answered Questions

[SOLVED] ROW_NUMBER() in MySQL

11 Answered Questions

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

6 Answered Questions

[SOLVED] How can an SQL query return data from multiple tables

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

14 Answered Questions

8 Answered Questions

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

7 Answered Questions

[SOLVED] ORA-00979 not a group by expression

24 Answered Questions

27 Answered Questions

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