
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Alankritha Ammu has Published 45 Articles

Alankritha Ammu
33K+ Views
Beautiful webpages are a very strong means of catching user attention. In this article, we are going to see how we can add an image as the background image of a web. Approach There are two approaches to setting an image as the webpage's background image, which we will learn in ... Read More

Alankritha Ammu
22K+ Views
To use a floating image in HTML, use the CSS property float. It allows you to float an image left or right. More property values include the following:Sr.No.Property Value & Description1noneNot floated2leftFloats to the left3rightFloats to the right4initialDefault valueExampleYou can try to run the following code to use floating image ... Read More

Alankritha Ammu
356 Views
The charCodeAt() method returns a number indicating the Unicode value of the character at the given index. Unicode code points range from 0 to 1, 114, 111. The first 128 Unicode code points are a direct match of the ASCII character encoding.The following parameter is supported by charCodeAt(index) −index − An integer ... Read More

Alankritha Ammu
132 Views
JavaScript date setUTCMinutes() method sets the minutes for a specified date according to universal time.The following are the parameters for setUTCMinutes(minutesValue[, secondsValue[, msValue]]) method −minutesValue − An integer between 0 and 59, representing the minutes.secondsValue − An integer between 0 and 59, representing the seconds. If you specify the secondsValue ... Read More

Alankritha Ammu
302 Views
To match a Unicode character specified by the hexadecimal number xxx with JavaScript Regular Expression, use the following −\uxxxxExampleYou can try to run the following code to match the hexadecimal number character xxxx. It matches the hexadecimal number 53 i.e. S − JavaScript Regular Expression ... Read More
How can we use a subquery that contains a reference to a table that also appears in the outer query?

Alankritha Ammu
779 Views
A subquery that contains a reference to a table that also appears in the outer query is called a correlated subquery. In this case, MySQL evaluates from inner query to the outer query. To understand it we are having the following data from table ‘cars’ −mysql> Select * from Cars; ... Read More

Alankritha Ammu
183 Views
Group functions are the function which applied to a group of rows or in other words group functions operate on sets of values. The following table gives the Description of MySQL group functions −Sr.No.Name & Description1AVG()It returns the average value of the argument.2BIT_AND()It returns bitwise AND.3BIT_ORIt returns bitwise OR.4BIT_XOR()It returns ... Read More

Alankritha Ammu
124 Views
MySQL converts the arguments of CHAR() function which is greater than 255 to multiple result bytes. For example, CHAR(260) is equivalent to CHAR(0, 1, 0, 4). It can be more clear with the help of following statements −mysql> Select HEX(CHAR(256)), HEX(CHAR(1, 0)); +----------------+----------------+ | HEX(CHAR(256)) | HEX(CHAR(1, 0)) | +----------------+----------------+ ... Read More

Alankritha Ammu
198 Views
Two functions can be used for this purpose and in both the functions we need to provide column name as an argument along with INTERVAL keyword. The functions are as follows −DATE_ADD() functionThe syntax of this function is DATE_ADD(date, INTERVAL expression unit). It can be demonstrated by following the example ... Read More

Alankritha Ammu
167 Views
MySQL returns NULL if we provide any non-hexadecimal number as an argument to UNHEX() function. Following example will demonstrate it.Examplemysql> Select UNHEX('ANK96598'); +-------------------+ | UNHEX('ANK96598') | +-------------------+ | NULL | +-------------------+ 1 row in set (0.00 sec)As we know that the valid hexadecimal digits ... Read More