
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
George John has Published 1081 Articles

George John
5K+ Views
The three clock cycles at the last stages in the IN 35H instruction is an example of machine cycle for IOR. The Waveforms for the IOR machine cycle are shown in the figure below.The point to be noted that in an IOR machine cycle, Wand Z has identical has port ... Read More

George John
1K+ Views
You need to use ORDER BY clause for this. Let us first create a table. The query to create a table is as followsmysql> create table OrderByDateThenTimeDemo - > ( - > Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, ... Read More

George John
2K+ Views
This example demonstrate about how to programmatically take a screenshot in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. ... Read More

George John
92 Views
The limit() method of the DoubleStream class returns a stream consisting of the elements of this stream, truncated to be no longer than max in length. The max is a parameter of the limit() method.The syntax is as followsDoubleStream limit(long max)Here, max is the number of elements the stream should ... Read More

George John
2K+ Views
Before having a discussion regarding the merits of I/O mapped I/O and demerits of memorymapped I/O, let us have a generic discussion regarding the difference between I/O mapped I/O and memory mapped I/O.In Memory Mapped Input Output −We allocate a memory address to an Input Output device.Any instructions related to ... Read More

George John
127 Views
To create Decade Tuple from another collection in Java, use the fromArray() or the fromCollection() method. Here, we will see how to create a Decade Tuple using the fromCollection() method. This method will allow us to crate a Decade Tuple from a List collection in Java.Let us first see what ... Read More

George John
5K+ Views
If you want case-insensitive distinct, you need to use UPPER() or LOWER().Case 1: Using UPPER().The syntax is as follows:SELECT DISTINCT UPPER(yourColumnName) FROM yourTableName;Case 2: Using LOWER().The syntax is as follows:SELECT DISTINCT LOWER(yourColumnName) FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is ... Read More

George John
1K+ Views
Here is the syntax of MySQL CASE OR conditionSELECT yourColumnName1, .....N , CASE WHEN yourColumnName2=0 or yourColumnName2IS NULL THEN 'yourMessage1' ELSE 'yourMessage2' END AS yourAliasName FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table ReservationSystems ... Read More

George John
99 Views
The iterator() method of the AbstractSequentialList class iterates over the elements in this list and returns it.The syntax is as followsIterator iterator()To work with the AbstractSequentialList class in Java, you need to import the following packageimport java.util.AbstractSequentialList;The following is an example to implement AbstractSequentialList iterator() method in JavaExample Live Demoimport java.util.LinkedList; ... Read More

George John
478 Views
This example demonstrate about How to create a dialog with Neutral options.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. In the ... Read More