How to Obtain the Second Distinct Highest Record using SQL?
Question: Write a SQL query to get the second highest salary (distinct) from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | …
Tag: SQL
How to Create a WordPress Page that Shows Comment Statistics?
October 18, 2014
beginner, code, database, implementation, php, programming languages, sql, web programming
No Comments
WordPress is based on PHP and MySQL. So it is very flexible and powerful. This article will guide you how to create a page that shows the comment statistics …
How to Get the list of emails from the WordPress Comments?
Suppose you have a wordpress blog and you want to send a email to say ‘thank you’ to all the people who left good comments (you approved them). You …
How to Create a Ranking Page in WordPress Based On GD Star Rating Plugin?
October 10, 2014
implementation, php, programming languages, sql, web programming, webhosting, wordpress
No Comments
The GD Star Rating Plugin is a famous plugin that allows readers (without login or registration) to give scores to articles, posts, pages and even comments. Therefore, it might …
How to Display Top 20 Comment-ed Articles in WordPress?
October 4, 2014
code, implementation, mysql, programming languages, web programming, webhosting, wordpress
1 Comment
Many bloggers use WordPress (The Famous and Recommended Content Management System CMS) nowadays. WordPress has a inbuilt comment system so that the readers can engage in the discussions. The …