What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-10 19:50:09
mysql fill in missing dates
MySQL doesn't have recursive functionality, so you're left with using the NUMBERS table trick - Create a table that only holds incrementing numbers - easy to do using an auto_increment: DROP TABLE IF EXISTS `example`.`numbers`; CREATE TABLE `example`.`... Add solution -
SQL 2021-10-02 06:43:06
how to check nls timestamp format in oracle
SELECT * FROM (SELECT 'SESSION' SCOPE, nsp.* FROM NLS_SESSION_PARAMETERS nsp UNION ALL SELECT 'DATABASE' SCOPE, ndp.* FROM NLS_DATABASE_PARAMETERS ndp UNION ALL SELECT 'INSTANCE' SCOPE, nip.* FROM NLS_INSTANCE_PARAMETERS nip) a PIV... Add solution -
SQL 2021-09-28 03:33:03
how to insert multiple records at once in sql acess
INSERT INTO target_table ( column_name1, column_name2 ) SELECT column_name1, column_name2 FROM (SELECT tableNameColumn AS column_name1, tableNameColumn2 FROM tableName, tableName2 WHERE tableNameColumn = 3 AND tableNameColumn2 = 1 UNION ALL SELECT tableN... Add solution -
SQL 2021-09-28 01:33:04
sql select most frequent value in column
SELECT col, COUNT(col) AS value_occurrence FROM m_table GROUP BY col ORDER BY value_occurrence DESC LIMIT 1; -- Oracle <= 11g SELECT * FROM (SELECT col, COUNT(col) AS value_occurrence FROM m_table GROUP BY col ORDER BY value_occurrence DESC) WHERE row... Add solution -
SQL 2021-09-15 21:21:01
sql get highest date from 3 tabels
SELECT MAX(MaxDate) FROM (SELECT MAX(TradeDate) AS MaxDate FROM Office.Transactions WHERE BrokerID = 1 AND TradeDate IS NOT NULLUNIONSELECT MAX(EntryDate) AS MaxDate FROM Office.IOI WHERE BrokerID = 1UNIONSELECT MAX(EntryDate) AS MaxDate FROM Office.Trade... Add solution