 
 Data Structure Data Structure
 Networking Networking
 RDBMS RDBMS
 Operating System Operating System
 Java Java
 MS Excel MS Excel
 iOS iOS
 HTML HTML
 CSS CSS
 Android Android
 Python Python
 C Programming C Programming
 C++ C++
 C# C#
 MongoDB MongoDB
 MySQL MySQL
 Javascript Javascript
 PHP 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
Chandu yadav has Published 1090 Articles
 
 
							Chandu yadav
118 Views
MySQL CONCAT() function will return a NULL if you will add a NULL value while linking two strings. Following example will demonstrate it −Examplemysql> Select CONCAT('Tutorials', NULL, 'Point'); +----------------------------------+ | CONCAT('Tutorials', NULL, 'Point') | +----------------------------------+ | NULL ... Read More
 
 
							Chandu yadav
423 Views
A number is an Armstrong number if the sum of the cube of each digit of the number is equal to the number itself.Here, we will find out the remainder and will sum it to the cube of remainder.rem = i % 10; sum = sum + rem*rem*rem;Then if the ... Read More
 
 
							Chandu yadav
120 Views
Actually, INTERVAL() function uses the binary search for searching the bigger number than the number at first argument. So, that is why if we want INTERVAL() function to work efficiently the list of numbers would be in ascending order. Following is a good way to use INTERVAL() function −mysql> Select ... Read More
 
 
							Chandu yadav
194 Views
For combining values of two or more columns, we can use MySQL CONCAT() function. In this case, the arguments of the CONCAT() functions would be the name of the columns. For example, suppose we have a table named ‘Student’ and we want the name and address of the student collectively ... Read More
 
 
							Chandu yadav
219 Views
Use the CSS :nth-last-child(n) selector to style every element that is the child of its parent, counting from the last child. You can try to run the following code to implement the :nth-last-child(n) selectorExampleLive Demo p:nth-last-child(4) { ... Read More
 
 
							Chandu yadav
413 Views
As we know that the default type of a bit values assigned to user variables is binary strings but we can also assign a bit value to a number by using the following two methods −By using CAST() functionWith the help of CAST(… AS UNSIGNED) the bit value can be ... Read More
 
 
							Chandu yadav
602 Views
The constants refer to fixed values that the program may not alter during its execution. These fixed values are also called literals. Constants can be of any of the basic data types like an integer constant, a floating constant, a character constant, or a string literal. There are also enumeration ... Read More
 
 
							Chandu yadav
1K+ Views
Non-static classes can be instantiated, whereas static classes cannot be instantiated i.e. you cannot use the new keyword to create a variable of the class type.Non-static classes can have instance method and static methods.Access the members of a static class by using the class name itself, whereas Static class is sealed.Example of ... Read More
 
 
							Chandu yadav
2K+ Views
Use the static method String.Format for form double string format in C#.For three decimal places −String.Format("{0:0.000}", 987.383); String.Format("{0:0.000}", 987.38); String.Format("{0:0.000}", 987.7899);For thousands separator −String.Format("{0:0, 0.0}", 54567.46); String.Format("{0:0, 0}", 54567.46);To format string −Exampleusing System; class Demo { public static void Main(String[] args) { Console.WriteLine("Three decimal ... Read More
