SQL

2,959 topics in this forum

1. SQL Tutorial and Reference

   By kaijim, September 28, 2005
   • 3 replies
   • 80.3k views
   • 
   • warend2
   • December 4, 2013

2. What does these codelines mean?

   By rootKID, Thursday at 01:23 PM
   • 0 replies
   • 26 views
   • 
   • rootKID
   • Thursday at 01:23 PM

3. Help with Mysql and PHP

   By Matthew Payton, May 12
   • 0 replies
   • 93 views
   • 
   • Matthew Payton
   • May 12

4. Deleting duplicates after joining two tables

   By Ashu96, February 9   

   • self join
   • delete
   • (and 1 more)

     Tagged with:

     • self join
     • delete
     • duplicates
   • 3 replies
   • 460 views
   • 
   • Ashu96
   • February 12

5. Seeking help to write a basic query

   By koralt, January 23
   • 0 replies
   • 168 views
   • 
   • koralt
   • January 23

6. sql Create $_SESSION vars from a SQL database table ie. $_SESSION[table_column_name] = table_column_1_row_value for any database table

   By Ralph, December 16, 2021   

   • column name
   • column value
   • 0 replies
   • 228 views
   • 
   • Ralph
   • December 16, 2021

7. Use of not with select statement

   By Bishal Chapagain, December 4, 2021
   • 2 replies
   • 166 views
   • 
   • niche
   • December 4, 2021

8. Create SP to Import JSON

   By David Craven, November 23, 2021   

   • sql
   • 1 reply
   • 213 views
   • 
   • David Craven
   • November 23, 2021

9. MySQL query help

   By Tauheed, November 16, 2021   

   • mysql
   • sql
   • (and 3 more)

     Tagged with:

     • mysql
     • sql
     • query
     • inner joins
     • count
   • 3 replies
   • 187 views
   • 
   • niche
   • November 18, 2021

10. PopSQL - connecting to server

    By Truman, November 9, 2021
    • 2 replies
    • 187 views
    • 
    • Truman
    • November 14, 2021

11. Showing INDEX on w3schools site

    By jmckeon, November 5, 2021
    • 1 reply
    • 144 views
    • 
    • niche
    • November 5, 2021

12. Wow to use sql to check if there's any value is null

    By Patty_Tu, October 18, 2021   

    • sql
    • null
    • (and 1 more)

      Tagged with:

      • sql
      • null
      • syntax question
    • 4 replies
    • 265 views
    • 
    • Patty_Tu
    • October 19, 2021

13. Questions about the usage of DISTINCT and NOT syntax

    By Patty_Tu, October 15, 2021   

    • sql
    • syntax question
    • (and 2 more)

      Tagged with:

      • sql
      • syntax question
      • distinct
      • not
    • 2 replies
    • 231 views
    • 
    • Patty_Tu
    • October 18, 2021

14. Automated(View or Stored Prosedure)

    By yrstruly, October 2, 2021   

    • view
    • stored procedure
    • 0 replies
    • 251 views
    • 
    • yrstruly
    • October 2, 2021

15. Help creating a query - SQL

    By Antra, September 26, 2021
    • 1 reply
    • 257 views
    • 
    • niche
    • September 26, 2021

16. Help creating a query

    By RicardoBett, September 15, 2021
    • 4 replies
    • 273 views
    • 
    • RicardoBett
    • September 16, 2021

17. conditional add clause

    By jimfog, September 7, 2021
    • 2 replies
    • 277 views
    • 
    • jimfog
    • September 12, 2021

18. Opening Stock, TotalStockIn, TotalStockOut, ClosingStock By Date sql Query

    By Priya22, July 8, 2021   

    • sql
    • ms-access
    • 1 reply
    • 432 views
    • 
    • niche
    • July 8, 2021

19. Create mysql query

    By Tor Erik Berg, June 9, 2021
    • 2 replies
    • 383 views
    • 
    • niche
    • June 12, 2021

20. problem in HAVING statement

    By GOBIN, May 23, 2021
    • 5 replies
    • 318 views
    • 
    • GOBIN
    • May 25, 2021

21. dedicate table for days closed or not?

    By jimfog, May 4, 2021
    • 0 replies
    • 335 views
    • 
    • jimfog
    • May 4, 2021

22. Help me

    By Hermii, April 26, 2021
    • 0 replies
    • 296 views
    • 
    • Hermii
    • April 26, 2021

23. Mulitple Left/Right Joins with the second one taking the first as table 1

    By Nok, April 6, 2021   

    • sql
    • joins
    • 0 replies
    • 428 views
    • 
    • Nok
    • April 6, 2021

24. Time Metrics/Order Detail -MSSQL

    By tonysa, March 18, 2021
    • 2 replies
    • 351 views
    • 
    • tonysa
    • March 19, 2021

25. How to do ETL using stored procedure

    By Anjaly, August 26, 2020
    • 1 reply
    • 608 views
    • 
    • Sherin
    • March 15, 2021