Second and Third Highest Salary using mysql

It is very easy to find second highest salary

SELECT *
FROM emp
WHERE salary =(SELECT salary
FROM emp
GROUP BY salary
ORDER BY salary DESC
LIMIT 1 , 1)

Third highest salary you can find following ways

SELECT *
FROM emp
WHERE salary =(SELECT salary
FROM emp
GROUP BY salary
ORDER BY salary DESC
LIMIT 2 , 1)


Most Popular

ReactJs Top Hooks List

 In today article we are going to show you some reactjs hooks which can help you to increase your reactjs knowledge.  What is hooks? Hooks are a new addition in React 16.8.  It allows you to use state and other React features without writing a class. Hooks are the functions which "hook into" React state and lifecycle features from function components. Following are some hooks which are most useful for you 1. useState Hook  React useState() is a built in hooks or function which comes with React library. When you want to use “useState” you need to first import in your application using following code sample.  useState() only work with functional components. This will not work with Class components in React. Visit original article here 2. useEffect Hook The useEffect() hook allows us to run side effects on your functional components. Side effects is a general concept about how functions behave which are not predictable. A function is supposed to have side effe...
Keep reading

The difference between React vs AngularJs

Image
React and AngularJs are currently using Travel and News companies. Main reason difference between AngularJs and ReactJs is AngularJS 1. AngularJs is MVC framework library. It is used for Two-way data binding. 2. AngularJs is an App development framework. ReactJS 1. React Js is a Library. It is used for One-way data binding. 2. ReactJs is an interface development framework. AngualrJs is a Javascript Framework. Where we can add HTML tags with Scrip tag. It is a Library written in Javascript. AngularJs developed by GOOGLE. AngularJs similar to Backbone or JavascriptMVC. It is a complete solution for rapid development. Following are some Features of AngularJs. 1. REST Easy: RESTful action quick communication between server to the client. 2. Extends HTML: AngularJS extends HTML with ng-directives. The ng-app directive defines an AngularJS application. The ng-model directive binds the value of HTML controls (input, select, textarea) to application data. The ng-bi...
Keep reading

crontab example in linux

Find Below example for crontab linux example. # Minute Hour Day of Month Month Day of Week Command # (0-59) (0-23) (1-31) (1-12 or Jan-Dec) (0-6 or Sun-Sat) 0 4 1 * 0 /usr/bin/example This line executes the "example" command at 4AM on the 1st of every month that a Sunday falls on. The -l option causes the current crontab to be displayed on standard output. The -r option causes the current crontab to be removed. The -e option is used to edit the current crontab using the editor specified by the VISUAL or EDITOR environment variables.  
Keep reading