Useful tips for everyday
How to split a text string at a certain character? Summary To split a text string at a certain character, you can use a combination…
Do all columns in a SELECT list have to appear in a GROUP BY clause? If you specify the GROUP BY clause, columns referenced must…
Which command creates a database in PostgreSQL? createdb creates a new PostgreSQL database. Normally, the database user who executes this command becomes the owner of…
How do I reclaim MySQL disk space? Reclaim Your Hard Drive – Saving Tons of Space with MySQL InnoDB tables Export/dump all your databases. Drop…
How do you lock a table in redshift? 1 Answer Open a connection to the database and invoke the begin and lock commands against your…
Can you SUM distinct? DISTINCT instructs the SUM() function to calculate the sum of the only distinct values. expression is any valid expression that returns…
How to obtain a value in one column based on another column? If you have unique values in Column B i.e. there’s only one minimum…
Is clustered index must be unique? SQL Server does not require a clustered index to be unique, but yet it must have some means of…
How to add a checkbox parameter in a ssrs report? Select checkbox column and right click -> Text box properties -> Select Action Properties, as…
Can Postgres send email? Sends emails from a PostgreSQL Database using Python3 (plpython3u) This is a simple function in plpython3u (Python3) that sends an email…