To order by a field and list the NULL values first, you need to use the following syntax. This will order in descending order −select yourColumnName from yourTableName group by yourColumnName is null desc, yourColumnName desc;To understand the above syntax, let us first create a table −mysql> create table OrderByNullFirstDemo ... Read More

In this program we will see how to sort a block of bytes in descending order using bubble sorting technique.Problem StatementWrite8085 Assembly language program to sort numbers in descending order where n number of numbers are stored in consecutive memory locations starting from 8041H and the value of n is ... Read More

In this program we will see how to divide a 16-bit number by an 8-bit numberProblem StatementWrite 8085 Assembly language program to divide a 16-bit number by an 8-bit number.DiscussionIn this program we are taking the 16-bit number from 8000H and 8001H. The 8000H is holding the lower order byte ... Read More

The microcomputer system basically consists of three blocksThe microprocessorThe memories of microprocessor like EPROM and RAM andThe I/O ports by which they are connected.The possible data transfers are indicated below.Between the memory and microprocessor data transfer occurs by using the LDA and STA instructions.Between microprocessor and I/O ports also data ... Read More

In this program we will see how to find the HCF or GCD of two numbers using 8085.Problem StatementWrite 8085 Assembly language program to find the HCF of two numbers stored at memory location 8000H and 8001H.DiscussionThis problem is solved by the Euclidean algorithm to find HCF. This algorithm is ... Read More

We have four Counters, ranging from CR3-0, which consists of 16 bits each. At the time when the CR becomes access to the processor which is 16-bits wide, the Least Significant and the Most Significant Byte of the register are accessed in an alternate manner, which starts with the Least ... Read More

Now let us see a program of Intel 8085 Microprocessor. This program will find the LCM of two8-bit numbers.Problem StatementWrite 8085 Assembly language program to find LCM of two 8-bit numbers stored at location8000H and 8001HDiscussionIn this program we are reading the data from 8000H and 8001H. By loading the ... Read More

Many situations may arise, where a microcomputer system requires accurate time delays. For example, when we implement a real time clock, the time needs to get updated at least for once in every second.We generate accurate time delays by using a few instructions in a loop.It is completely software based, ... Read More

To count distinct values, you can use distinct in aggregate function count().The syntax is as follows −select count(distinct yourColumnName) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The following is the query to create a table −mysql> create table DistinctDemo −> ( ... Read More

To validate email and phone in swift language we can use multiple conditional statements like if conditions, but that’s a long process and may contain 50-100s of if statements to validate email.So instead of conditionals we’ll use Regular expression. Swift provides NSPredicates which we can use to evaluate a regular ... Read More