Getting the first & Second highest number record from a table

Let us say that we want the Second record afther the first we will have something like this :

SELECT * FROM student ORDER BY Student.Name Asc LIMIT 1,1

or another example Selecting the first record showing the biggest grade in a exam for a student (just the first record)

SELECT * FROM StudentGrades ORDER BY StudentGrades.Grade Desc LIMIT 0,1

Comentarii

Trimiteți un comentariu

Postări populare de pe acest blog

RpiCar

Imagine
Raspberry PI & Node JS I'm glad to share my first Iot project a car that runs on 2 servo motors Requisite list: -Power bank for Raspberry pi (one external for phone should do the trick with 2.1 A) - Raspberry pi (B/B+/2/3) - I'm using 3 - You can get one from here - 2 servo wheels - You can buy them from here -  L298N Dual H-Bridge Motor Controller - You can buy from here -Power bank max 12V for controller - I recommend this one How to connect everything schema: Software ... NodeJS How to install: Step 1: sudo apt update sudo apt dist-upgrade sudo rpi-upgrade Step 2: curl -sL https://deb.nodesource.com/setup_5.x | sudo -E bash - sudo apt-get install -y nodejs node -v v5..... Step 3: create a folder and: npm install  rpio console express body-parser cors Step 4: go to github here ... Website Install Lighttpd and in /var/www/html copy files from here: https://github.com/alexandru360/RpiCar/tree/...
Citiți mai multe

Building Cross-Platform Desktop Apps with Electron.NET

This article provides a walk-through for developing and deploying an application with Electron.NET. Create an ASP. NET Core Web Application For this exercise, I'm using Visual Studio Code. First, open a terminal window and run the following commands to create a new project called ElectronMvcDemo . mkdir ElectronMvcDemo   cd ElectronMvcDemo   dotnet new webapp   code .   When prompted by Visual Studio Code, say Yes to load the required assets for the project. Press F5 to build and run the application, opening a browser on the default ASP. NET Core welcome page, hosted on localhost:5001. Close the page, return to VS Code and stop debugging. Electronize It! Now let's turn our boilerplate ASP. NET Core project into an Electron application. First, open the file ElectronMvcDemo.csproj and insert a package reference for the Electron.NET: <ItemGroup>     < PackageReference Include= "ElectronNET.API" Version= "9.31.2" /...
Citiți mai multe

NodeJS - Npm - set global node_modules

Ever had the problem of 'XXXXX'( 'yarn' )  is not recognized as an internal or external command ?! The solution is as follows: mkdir % PROGRAMDATA % \npm setx PATH "%PROGRAMDATA%\npm;%PATH%" / M npm config set prefix % PROGRAMDATA % \npm Explanation: Create a folder in a sensible location to hold the globals (Microsoft is adamant that you shouldn't write to ProgramFiles, so %PROGRAMDATA% seems like the next logical place. The directory needs to be on the path, so use  setx .. /M  to set the system path (under HKEY_LOCAL_MACHINE). This is what requires you to run this in a shell with administrator permissions. Tell  npm  to use this new path. (Note: folder isn't visible in %PATH% in this shell, so you must open a new window). npm config ls - l | grep prefix -> This is to list all node_modules configured ... 
Citiți mai multe