Nth Highest Distinct Record using SQL
Write a SQL query to get the nth highest distinct salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 …
Tag: SQL
Posting SQL code on bbForum Triggers Security Rules by CloudFlare
February 18, 2016
cloud, CloudFlare, cloudflare, security, sql, wordpress, wordpress plugin
No Comments
I was trying to post some reply containing SQL code on bbForum and somehow it leads to this page: I have tried setting the security level from medium to …
How to Get Popular Posts of the Year using SQL? (2015)
At the end of each year, as a blogger, you might be interested in knowing the list of top popular posts of the year. Luckily, this can be easily …
Better SQL Insert Syntax
The SQL Insert statement is used when you want to insert new rows of data into the existing tables. For example, if a table has fields A, B, C …
Send Emails using Crontab for Your Web Applications
In your web applications, sometimes you would need to send users tons of emails. You can send them real time when users e.g. press a send button. But this …