Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Ankith Reddy
Page 62 of 73
How to find absolute difference between two numbers in MySQL?
To get the difference between two number in MySQL, let us first create a demo tablemysql> create table findDifferenceDemo -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> FirstNumber float, -> SecondNumber float -> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into findDifferenceDemo(FirstNumber, SecondNumber) values(4.2, 2.3); Query OK, 1 row affected (0.20 sec) mysql> insert into findDifferenceDemo(FirstNumber, SecondNumber) values(23.4, 5.6); Query OK, 1 row affected (0.14 sec) ...
Read MoreTemporary (temp) register in 8085 Microprocessor
Temporary register is also an 8-bit register which the programmer can’t access at all. It is temporarily stored inside 8085 microprocessor which is 8 bit operand to the instruction set. For example, when the fetching of instructions “MVI M, 34H” is done the instruction register IR register will receive the opcode for MVI M, and the Temp register receives 34H.The operations of arithmetic and logical sequence carried out involves two operands, among which one is operand is provided by the accumulator, and the other operand is provided by the Temp register. For example, in the addition process the instruction to ...
Read MoreConcatenate strings from two fields into a third field in MongoDB?
To concatenate strings from two fields into a third field, you can use the following syntaxdb.yourCollectionName.aggregate( [ { $project: { "yourNewFieldName": { $concat: [ "$yourFieldName1", " yourDellimiterValue ", "$yourFieldName2" ] } } } ] );Let us first create a collection with documents>db.concatenateStringsDemo.insertOne({"StudentFirstName":"John", "StudentLastName":"Doe"}); { "acknowledged" : true, "insertedId" : ObjectId("5c9bb7362d66697741252444") } >db.concatenateStringsDemo.insertOne({"StudentFirstName":"John", "StudentLastName":"Smith"}); { "acknowledged" : true, "insertedId" : ObjectId("5c9bb7402d66697741252445") } >db.concatenateStringsDemo.insertOne({"StudentFirstName":"Carol", "StudentLastName":"Taylor"}); { "acknowledged" : true, "insertedId" : ObjectId("5c9bb74c2d66697741252446") } >db.concatenateStringsDemo.insertOne({"StudentFirstName":"David", "StudentLastName":"Miller"}); { "acknowledged" : true, "insertedId" : ObjectId("5c9bb7752d66697741252447") } >db.concatenateStringsDemo.insertOne({"StudentFirstName":"James", "StudentLastName":"Williams"}); { "acknowledged" : ...
Read MoreOrder by a function of two columns in a single MySQL query
Let us first create a tablemysql> create table orderByAFunctionDemo -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> FirstNumber int, -> SecodNumber int -> ); Query OK, 0 rows affected (0.44 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into orderByAFunctionDemo(FirstNumber, SecodNumber) values(10, 4); Query OK, 1 row affected (0.11 sec) mysql> insert into orderByAFunctionDemo(FirstNumber, SecodNumber) values(45, 78); Query OK, 1 row affected (0.17 sec) mysql> insert into orderByAFunctionDemo(FirstNumber, SecodNumber) values(23, 10); Query OK, 1 row affected (0.12 sec) mysql> insert into orderByAFunctionDemo(FirstNumber, SecodNumber) values(67, ...
Read MoreWhat do the id and scope attribute mean in the action elements in JSP?
These are two attributes that are common to all Action elements: the id attribute and the scope attribute.Id attributeThe id attribute uniquely identifies the Action element and allows the action to be referenced inside the JSP page. If the Action creates an instance of an object, the id value can be used to reference it through the implicit object PageContext.Scope attributeThis attribute identifies the lifecycle of the Action element. The id attribute and the scope attribute are directly related, as the scope attribute determines the lifespan of the object associated with the id. The scope attribute has four possible values:(a) ...
Read More8085 program to count the number of ones in contents of register B
In this program, we will see how to count the number of 1’s in an 8-bit number stored in register B.Problem StatementWrite 8085 Assembly language program to count the number of 1s in 8-bit number stored in register B.DiscussionIn this program, we are using the rotate operation to count the number of 1’s. As there are 8 different bits in 8-bit number, then we are rotating the number eight times. we can use RRC or RLC. Here we have used the RRC instruction. This instruction sends the LSb to MSb also to carry flag. So after each iteration, we can ...
Read More8085 Program to Subtract two multi-Byte numbers
Now let us see a program of Intel 8085 Microprocessor. This program is mainly for subtracting multi Byte numbers.Problem Statement:Write 8085 Assembly language program to add two multi-Byte numbers.Discussion:We are using 3-Byte numbers. The numbers are stored into the memory at location 8001H and 8004H. One additional information is stored at location 8000H. In this place we are storing the Byte count. The result is stored at location 8050H.We are taking the address of first operand block address into DE register pair, and the second operand block address into HL pair. The BC register pair is storing the destination address ...
Read MoreC++ Program to Implement a Binary Search Algorithm for a Specific Search Sequence
In this Program we need to implement binary search to find the existence of a search sequence in an array. The time complexity of Binary search is O(log(n)).Required steps and pseudocodesBegin BinarySearch() function has ‘arr’ the array of data and ‘n’ the number of values, start and end index, iteration count and b[0] be the element to be searched in the argument list. Increment the iteration counter and compare the item value with the a[mid]. If item < a[mid] choose first half otherwise second half to proceed further. Return index value to main. In main(), ...
Read More8085 program to reverse 8 bit number
In this program we will see how to reverse the digits of an 8-bit number using 8085.Problem StatementWrite 8085 Assembly language program to reverse an 8-bit number stored at location 8000H. Also, store the result at 8050H.DiscussionHere the task is too simple. There are some rotating instructions in 8085. The RRC, RLC are used to rotate the Accumulator content to the right and left respectively without carry. We can use either RRC or RLC to perform this task.InputAddressData……80004C……Flow Diagram ProgramAddressHEX CodesLabelsMnemonicsCommentsF0003A, 00, 80 LDA 8000HTake the number from memoryF0030F RRCRotate right without carry four timesF0040F RRC F0050F RRC F0060F RRC F00732, 50, 80 STA 8050HStore the result at memoryF00A76 HLTTerminate the ...
Read MoreAssembly program to transfer the status of switches
In this program we will see how to transfer the switch values from one port to another using 8085 and 8255 chip.Problem Statement:Write 8085 Assembly language program for interfacing between 8085 and 8255. Here eight switches are connected at port A. Transfer the status of these switches into port B. In port B the LEDs are connected.Discussion:The task is very simple. At first we have to setup the control word register of 8255 chip. After that we will take the input from port A, and send it to port B.The control word register is looks like this. It is holding ...
Read More