How to find out Second Highest Salary from the EMPLOYEE Table


  • DataBase Name : Prac
  • Table Name : Emp_Sal
I already added a four tuples into a "Emp_Sal" table.
I used SELECT query on "Emp_Sal" table. Result is,














We have to find out Second highest salary from " Emp_Sal " table, this table include four tuples and clearly shows that Employee name "PQR" is Second highest salary. 
So, Query is 






this query shows, i used two variable "MainTable" And "Auxillary". I compare one table using two variable. I get appropriate result,

OUTPUT:












I am changing variable name,
Instead of "MainTable" variable and "Auxillary" variable I used "e1" and "e2" variable respectively,
Query is,







This query successfully execute or not, let us see.












I  find out second highest salary from "EMPLOYEE" table.


Comments

  1. madrepadleyMarch 4, 2022 at 12:00 PM

    A Guide to Slots and Casino Games - DrMCD
    The most important thing about the 동두천 출장마사지 slot machines is that 경상남도 출장안마 they are 나주 출장안마 not random. The fact that 구리 출장마사지 most 문경 출장마사지 of these machines can operate with a random number is demonstrated in

    ReplyDelete

Post a Comment

Popular posts from this blog

Angular 4 + Cordova Boilerplate ::: Hybrid Mobile Application

Angular 4 + Cordova Hybrid Mobile App set up : ng-four-hybid-app : Angular 4 + Cordova boilerplate This project is using Angular 4 + Cordova boilerplate configurated. You can start building your great Hybrid Cordova Mobile Apps in Angular 4. Installation Install Node.js from:  https://nodejs.org/en/download/ Install Cordova using:  npm install -g cordova Clone ngCordova repository:  https://github.com/mithabavkar/ng-four-hybid-app.git Go to ngCordova repository:  cd project_name Install dependencies:  npm install Development server Development project folder is  src/ . You should start building your Angular 4 app there! Run  ng serve  for a dev server. Navigate to  http://localhost:4200/ . The app will automatically reload if you change any of the source files. Build Angular project Run  ng build  to build the Angular project. The build artifacts will be stored in the  www/  directory. Use the  -prod  flag for a production build. Adding Cordova platform
Read more

In MVC 4 Save and Retrieve cookies

In MVC 4 How to save and retrieve cookies. Follow these steps for Save Cookies :- 1. User validation successful then save UserID or UserName In cookies .In Login controller write these code: Code: var UserIDCookies = new HttpCookie("UserID",UserID); // Define cookies name UserIDCookies.HtpOnly=true; // assign UserID for save in cookies Response.Cookies.set(UserIDCookies); // User ID set in cookies 2. When ever you want to Retrieve UserID from cookie. Code: var UserID - Request.cookies.Get("UserID").value; In simple bracket of "UserID" name match with stored cookie name. cookie value store in Variable called UserID. You get UserID from cookies and store in variable. You want to convert string to int in MVC just write single line code. int ID = Convert.ToInt32("UserID");
Read more