SQL Query on SQL Expert Personal

  • SortOrder Related
    • Finding duplicate value of SortOrder (from StackOverflow)
      • SELECT SortOrder, COUNT(*) c FROM DataCenter GROUP BY SortOrder HAVING c > 0
    • Update DataCenter Set SortOrder = SortOrder-1 WHERE SortOrder>10
    • Update DataCenter Set SortOrder = SortOrder-1
    • SELECT SortOrder, * FROM DataCenter WHERE IDBangou IS NULL ORDER BY SortOrder ASC
    • SELECT SortOrder, * FROM DataCenter ORDER BY SortOrder
    • SELECT SortOrder, * FROM DataCenter ORDER BY rowid
  • SELECT rowid, * FROM ShukkoKiroku WHERE IDBangou=’M4616′
  • SELECT rowid, * FROM NyuukoKiroku
  • SELECT IDBangou, GenzaiZaikosuu, ZaikoSuu, NyuukoSousuu, ShukkoSousuu FROM DataCenter WHERE IDBangou = ‘M1338’ OR IDBangou = ‘M1018’
  • SELECT COUNT(*) FROM NyuukoKiroku
  • SELECT * FROM NyuukoKiroku WHERE IDBangou = ‘M1096’
  • SELECT SUM(Suuryou) FROM ShukkoKiroku WHERE IDBangou = ‘M1338’
    w3schools ref