Blog
Date manipulation using SQL query
8 Sep, 14

Date manipulation using SQL query

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...
Custom sorting in sql
5 Sep, 14

Custom sorting in sql

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...
Using SQLFiddle
29 May, 14

Using SQLFiddle

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...
Generate CSV file using MYSQL command
22 May, 14

Generate CSV file using MYSQL command

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...
SQL Joins
7 Apr, 14

SQL Joins

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...