BLOG | knowit | Page 3 of 5

Sql Backup table (create a new table from old)

Select * into NEW TABLE_15_02_2107 from SOURCE TABLE;

Last 15 mins where last_modified_on >= (sysdate-0.15/24) Last one hour where last_modified_on >= (sysdate-1/24)

SELECT d.Company, d.[Year], SUM(CASE WHEN [Month] = 01 THEN Transactions ELSE 0 END) AS Jan, SUM(CASE WHEN [Month] = 02 THEN...

PowerShell PowerShell offers much more flexibility for renaming files in a command-line environment. Using PowerShell, you can pipe the...

SELECT * FROM (SELECT * FROM PIM_CONTACT t ORDER BY last_modified_on desc ) WHERE ROWNUM = 1;

The *.BAT file content: ftp -v -n -s:c:\Transfer\transfer.ftp The transfer.ftp file content: open 127.0.0.1 user USER PASSWORD cd / ...

The *BAT file content: MOVE D:\nav360vca\ETL\Log\*.* D:\nav360vca\ETL\Log\Old

SELECT user_id FROM `table name` ORDER BY marks DESC, date_added ASC --LIMIT 1

SET rowcount 1 DELETE FROM [IVR_CONFIG_DB].[dbo].[TBL_IVR_CUSTOMERS] WHERE [TXT_CUST_TEL_NUM] = '123456789' SET rowcount 0

1 second Moving traffic Fast moving clouds Drivelapses 1- 3 seconds Sunsets Sunrises Slower moving clouds Crowds Moon and sun...