Div Mod SQL
-
i want to make sql statment that use mod % Div / i have tow colum tt | time --------- 1 | 1 2 | 2 3 | 9 i want to make list for all record if (time % 5 = 0) * how can make this
Palestine
-
i want to make sql statment that use mod % Div / i have tow colum tt | time --------- 1 | 1 2 | 2 3 | 9 i want to make list for all record if (time % 5 = 0) * how can make this
Palestine
you could make this by typing the query and executing it. the query has to be written according to your database rules (most likely sql 92 standard). the modulus operator is available too (and its the %-char). as a special hint: use the where clause (where x % 5 = 0)...
-
i want to make sql statment that use mod % Div / i have tow colum tt | time --------- 1 | 1 2 | 2 3 | 9 i want to make list for all record if (time % 5 = 0) * how can make this
Palestine
select * from [TableName] where time % 5 = 0 Kind Regards, John Petersen