How to sort SQL table by column?

Today I come across with a complex sql query requirement where I have to filter a table on a column entry and then sort according to date. The SQL language have some inbuilt keywords like ORDER to sort out this type of

Read More

Learn python try and except statements with examples

The try and except statements in python helps us to mitigate exception errors with a meaning full way. To understand why we require try and except statements we should know how python handles execution and syntax errors. There are two types of errors

Read More

Difference between Python range and xrange functions?

Python have two built-in functions which are useful to generate a sequence of numbers. These two functions are useful when you want to do iteration using for loop. Though both of the functions do same work like generating sequence but the way

Read More

PFOTD: Python bin(), oct() and hex() functions for base conversions

Today our python built-in function(s) are bin(), oct() and hex() which are useful for converting any type of number like negative, integer and large to their respective base numbers. Need of bin(), oct() and hex() function in Python: When we are doing some math work it is

Read More

PFOTD: Python abs() function examples

Today our python built-in function is abs() which is useful for converting any type of number like complex, negative, integer and large to its absolute number.  Need of abs() function in Python: When we are doing some math work it is require

Read More

SQL query: Search for multiple values in same field

Some times if we want to update a table or query a table for multiple values in a single column we have to run our simple sql query multiple times. Suppose if you want to get an element value in a column of

Read More

AWK ignore case(CAPS/lower) while patten search

Recently I come across a requirement to search for lines in a given file/files where the search term is mix of capital letters and small letters. Normally when we search with awk it search exactly what we try to search but not

Read More

Sed/paste/AWK/Perl: Merge or Join two lines

In this post we will see how to merge lines in a given file or standard output.  sed 'N;s/n/ /' filename paste -d " " – – < filename

Read More

Amazon AWS Regions vs Availability Zones vs Edge locations vs Data centers

In this post I tried to highlight different physical and virtual connection points which will make you to understand different AWS connections. The reason for this post is, I did not see much documentation which explain difference between these stuff and some things

Read More

What are Amazon AWS Availability Zones(aka AZ’s)?

When we are moving to Amazon AWS cloud we should know some of the basic concepts like Regions, service available, security etc. In this list there is one more basic concept called Availability Zones aka AZ. What is AWS Availability zone? Before

Read More

banner