I have written some useful query. When you need some customization in date format and find some prior date using SQL then below query might be useful for you. Find prior/future date from the current/given date: SELECT now()::date + 2 AS date1, current_date -1 AS date2...

Order by with a particular value on TOP or Custom sorting in order by clause. ORDER clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the result set by specified column list. When used with character data type columns it...

Hi Guys, this is my second blog post of this month. The title is “Using SQLFiddle”. In this post I am going to explain about a very useful online tool SQLFiddle which I have been using for a while. As JSFiddle is used to run and test CSS, JQuery etc, using...

Hello Guys! This is my first blog post of this month and the topic is “Generate CSV file using MYSQL command” In this post I will discuss about an interesting feature of MYSQL. MySQL provides an easy way for generating csv files by writing the output of a...

Hello Guys! This is my first blog post of this month and in this post I am going to explain about SQL Joins which is considered to be a very integral topic of SQL. The examples shown in this post have been taken from www.tutorialspoint.com. SQL join is a clause which...