Category: database
Last month, in my R tutorial, I showed you how to connect to SteemSQL in R script. The latest R Studio has added a connection tab, which is a …
If you have a following list that you would like to unfollow if he/she is inactive for at least 7 days, you might run the following SQL query (thanks …
R is suitable for data analysis and we can use R to do machine learning after mining the data from STEEMSQL. The first step is to connect to STEEMSQL, …
If you have lots of rows to insert into a MySQL table, you might experience it taking ages to complete. For example, I have around 100K rows to insert …
Write a SQL query to get the nth highest distinct salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 …