### Posts From askiguru

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

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

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

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

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

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

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

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

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

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