What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-27 19:20:39
sql group by error
SET GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_... Add solution -
SQL 2022-03-27 17:05:02
sql developer sql worksheet not showing
I was able to solve this by : Closing SQL developer Deleting the file SqlHistory.xml that is located at C:\Users\AppData\Roaming\SQL Developer\. Alternatively, you can rename it to e.g SqlHistoryOLD.xml Now when you open SQL developer and create a new SQ... Add solution -
Other 2022-03-27 13:10:01
window.partitionby
import sys from pyspark.sql.window import Window import pyspark.sql.functions as func windowSpec = \ Window .partitionBy(df['category']) \ .orderBy(df['revenue'].desc()) \ .rangeBetween(-sys.maxsize, sys.maxsize) dataFrame = sqlContext.tabl... Add solution -
Other 2022-03-20 00:10:03
función para generar slug directamente en MySQL
DROP FUNCTION IF EXISTS `slugify`; DELIMITER ;; CREATE FUNCTION slugify(str VARCHAR(255)) RETURNS VARCHAR(255) LANGUAGE SQL DETERMINISTIC NO SQL SQL SECURITY INVOKER BEGIN DECLARE slug, allowed_chars VARCHAR(255); DECLARE current_char V... Add solution -
SQL 2022-03-19 07:00:17
sp in sql server
Stored procedure A sp is group of T-SQL statement. If you have any kind of situation, where you are writing the same query over and over again, you can save that specific query as a stored procedure and then just call by it's name. Basically wrapped thi... Add solution
Best helpers
Ranking is empty