Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
You can use subquery with aggregate COUNT(*) to get the total row count. Let us first create a table −mysql> create table DemoTable ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar(20), StudentAge int ); Query OK, 0 rows affected (0.48 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(StudentFirstName, StudentAge) values('John', 23); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable(StudentFirstName, StudentAge) values('Larry', 21); Query OK, 1 row affected (0.40 sec) mysql> insert into DemoTable(StudentFirstName, StudentAge) values('Johnny', 23); Query OK, 1 row affected (0.43 sec) mysql> insert into DemoTable(StudentFirstName, StudentAge) ... Read More
Let us first create a List:List emp = Arrays.asList( new Employee("John", "Marketing", 5), new Employee("David", "Operations", 10));We have class Employee with name, department and rank of employees.Now, create summary for the rank like count, average, sum, etc:IntSummaryStatistics summary = emp .stream() .collect(Collectors.summarizingInt(p -> p.rank));The following is an example to create IntSummaryStatistics from Collectors in Java:Exampleimport java.util.Arrays; import java.util.IntSummaryStatistics; import java.util.List; import java.util.stream.Collectors; public class Demo { public static void main(String[] args) throws Exception { List emp = Arrays.asList(new Employee("John", "Marketing", 5), new Employee("David", "Operations", 10)); IntSummaryStatistics summary = emp .stream() .collect(Collectors.summarizingInt(p → ... Read More
These instructions are used to control the processor action by setting/resetting the flag values.These are the process/processor control instructions.OpcodeOperandDescriptionSTC----Used to set carry flag CY to 1CLC----Used to clear/reset carry flag CY to 0CMC----Used to put complement at the state of carry flag CY.STD----Used to set the direction flag DF to 1CLD----Used to clear/reset the direction flag DF to 0STI----Used to set the interrupt enable flag to 1, i.e., enable INTR input.CLI----Used to clear the interrupt enable flag to 0, i.e., disable INTR input.
Before getting into example, we should know what singleton design pattern is. A singleton is a design pattern that restricts the instantiation of a class to only one instance. Notable uses include controlling concurrency and creating a central point of access for an application to access its data store.Synchronized means only one thread can access at a time.This example demonstrates How to use singleton dialog using synchronized in androidStep 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 ... Read More
The syntax to get names of all keys in the collection is as follows:var yourVariableName1=db.yourCollectionName.findOne(); for(var yourVariableName 2 in yourVariableName1) { print(yourVariableName); }To understand the above syntax, let us create a collection with documents. The collection name we are creating is “studentGetKeysDemo”.The following is the query to create documents:>db.studentGetKeysDemo.insert({"StudentId":1, "StudentName":"Larry", "StudentAge":23, "StudentAddress":"US", ... "StudentHobby":["Cricket", "Football", "ReadingNovel"], "StudentMathMarks":89, "StudentDOB":ISODate('1998-04-06')});The following is the output:WriteResult({ "nInserted" : 1 })Display all documents from a collection with the help of find() method. The query is as follows:> db.studentGetKeysDemo.find().pretty();The following is the output:{ "_id" : ObjectId("5c6c12dd68174aae23f5ef5f"), "StudentId" : 1, "StudentName" : ... Read More
The tag is used to specify the time zone that all tags within its body will use.AttributeThe tag has the following attributes −AttributeDescriptionRequiredDefaultValueTime zone to apply to the bodyYesNoneExample JSTL fmt:timeZone Tag Formatting: The above code will generate the following result −Formatting: 23 September 2010 15:09:09 GST Etc/GMT+1222-Sep-2010 23:09:09Etc/GMT+1123-Sep-2010 00:09:09
The remove() method of the AbstractSequentialList class removes the element at the specified position in this list.The syntax is as followsE remove(int index)Here, index is the index of the element to be removed. 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 remove() method in JavaExample Live Demoimport java.util.LinkedList; import java.util.AbstractSequentialList; public class Demo { public static void main(String[] args) { AbstractSequentialList absSequential = new LinkedList(); absSequential.add(25); ... Read More
Use the fromCollection() method to create a Decade tuple from a List collection in Java. Let us first see what we need to work with JavaTuples. To work with Decade class in JavaTuples, you need to import the following package.import org.javatuples.Decade;Note Download JavaTuples Jar library to run JavaTuples program. If you are using Eclipse IDE, then Right Click Project -> Properties -> Java Build Path -> Add External Jars and upload the downloaded JavaTuples jar file. Refer the below guide for all the steps to run JavaTuples.Steps: How to run JavaTuples program in EclipseThe following is an example to create ... Read More
The only safe way is to check for overflow before it occurs. There are some hacky ways of checking for integer overflow though. So if you're aiming for detecting overflow in unsigned int addition, you can check if the result is actually lesser than either values added. So for example, Example Codeunsigned int x, y; unsigned int value = x + y; bool overflow = value < x; // Alternatively "value < y" should also workThis is because if x and y are both unsigned ints, if added and they overflow, their values can't be greater than either of them ... Read More
To understand the concept, let us first create a table. The query to create a table is as followsmysql> create table ReorderSortDemo -> ( -> UserId int -> ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into ReorderSortDemo values(14); Query OK, 1 row affected (0.13 sec) mysql> insert into ReorderSortDemo values(4); Query OK, 1 row affected (0.10 sec) mysql> insert into ReorderSortDemo values(6); Query OK, 1 row affected (0.11 sec) mysql> insert into ReorderSortDemo values(3); Query ... Read More