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

Derivatives stock list at NSE

Complete FNO stock list at NSE. ABB India Ltd ACC Ltd APL Apollo Tubes Ltd AU Small Finance Bank Ltd Aarti Industries Ltd Abbott India Ltd A...