Posts From askiguru

How to De-stress at Work?

Do you feel bored and get stressed out at work? No matter how much effort we put in, but it gets difficult to be a multi-tasker. In corporate world, people are usually stressed out due to deadlines, appointments, meetings and targets. Unwanted stress may stop you from seeing things clearly and may be a hurdle in achieving your goals. Here is a list of some tips that will help you

An important Safety Tip for Women

Currently such a situation prevails in our country that women feel unsafe to roam or travel alone at night. Women are generally advised to keep pepper spray, red chili powder or some sort of small pointed weapon that they can use for their self defense if any such situation occurs. Apart from all these precautions women should be alert while travelling alone and note down the number of the rickshaw

How to Stay Active During Winter

Winter generally turns out to be the laziest season out of all. You tend to stay indoors rather than going out and doing activities. Health Experts suggest that in winter eating right food and doing the right type of exercises build your energy for the entire year. It lets you to focus on exercise for the right reasons. Here is a list of few sports activities which will make you

Feng Shui Tips for a Happy Home

We all are surrounded by energy. With the help of Feng Shui, we can balance the energy in a way that it helps us eliminate the negative energy around us, capturing only the positive energy to make our lives better. They say, “Home is where the story begins”, and to make it a peaceful place to dwell in, below are some of the Feng Shui tips: The Entrance: When someone

How to convert from Lowercase to Uppercase in SQL?

To convert or change the value of a field from lowercase to uppercase, the UCASE() function is used.   SQL UCASE() Syntax is as follows: Select UCASE(column_name) From table_name;   Let us consider the below Students table: roll_no Name total_marks (out of 600) percentage grade 1 Ashok 392 65.33 B 2 Chaitali 454 75.67 A 3 Smriti 502 83.60 A 4 Kaushik 337 56.10 C   The following SQL statement

How to calculate sum of the numeric columns in SQL?

To sum up or to do the addition of the numeric column of the table,the SUM() function is used.   SQL SUM() Syntax is as follows: Select Sum(column_name) From table_name;   Let us consider the below Students table: roll_no Name total_marks (out of 600) percentage grade 1 Ashok 392 65.33 B 2 Chaitali 454 75.67 A 3 Smriti 502 83.60 A 4 Kaushik 337 56.10 C   Now suppose based

How to find the square root of numeric fields in SQL?

If you want to find the square root of any number, then the SQRT() Function is used. The Select Statement can be used to find the square root of any number as follows:   The SQRT() syntax is as follows: Select SQRT(number);   Example: Select SQRT(25); SQRT(25) 5.000000   You can see the float value because the SQL manipulates the square root in float data type. The SQRT() Function can

How to round off the numbers in SQL?

In order to round off a numeric field in a table that contains decimals, the ROUND() function is used. The numbers will be rounded to the nearest whole number.   SQL ROUND() Syntax is as follows: Select Round(column_name, decimals) From table_name;   Here, decimals mention the number of decimals that are to be returned.   Let us consider the below Students table: roll_no Name total_marks (out of 600) percentage grade

What is the use of random function in SQL?

When a Rand() is called, it displays random numbers between 0 and 1.   You can use Select statement to call Rand() Function:   For example, Select Rand(), Rand(); Rand() Rand() 0.45832146952763 0.72513571983465   It can be seen above that, 2 different values are displayed each time. To randomize a set of rows or values, you can use ORDER BY RAND() as follows:   Let us consider the following Students table: roll_no

How to fetch the current system time in SQL?

In order to return or fetch the current date and time of the system, the NOW() function is used.   SQL NOW() Syntax is as follows: Select Now() From table_name;   Let us consider the below Students table: roll_no Name total_marks (out of 600) percentage grade 1 Ashok 392 65.33 B 2 Chaitali 454 75.67 A 3 Smriti 502 83.60 A 4 Kaushik 337 56.10 C   Example: The following