Sunday, February 23, 2020

GROUPING and SORTING the same column of a table by SQL


How to group and sort the same column in a table https://www.w3resource.com/sql/aggregate-functions/count-with-group-by.php

Counting the number of times a particular value appears in a column

select studentID, 15*count(*) as Fees FROM orders GROUP BY studentID;

Friday, February 21, 2020

Assembly language instructions for popular processor familiies


1. Assembler instructions/ISA for AVR processors
(a) https://github.com/pravdomil/AVR-Instruction-Set
(b) https://www.microchip.com/webdoc/avrassembler/avrassembler.wb_instruction_list.html

2. ISA(Instruction Set Architecture) for PIC family of microcontrollers



3. ISA(Instruction Set Architecture) for ARM family of microcontrollers



4. ISA(Instruction Set Architecture) for x8086/85 family of microprocessors
https://www.felixcloutier.com/x86/
5. ISA(Instruction Set Architecture) for Motorola 68000 family of microprocessors
http://mrjester.hapisan.com/04_MC68/Index.html
6. CPU12/HSC12/M68HC12 instruction set
    (a) http://www.secs.oakland.edu/~llamocca/Courses/ECE470/FreescaleTraining_HCS12%20Instruction%20Set.pdf

Sacred Thought

26 April 2024  Dear friends, I write the explanation of two verses of Geets for all of you, I hope you all will like it and benefit from it....