SQL Query to find the Nth Highest Salary.

Option:1 SELECT * FROM SalaryTable S1 WHERE N-1 = ( SELECT COUNT(DISTINCT(S2.Salary)) FROM SalaryTable S2 WHERE S2.Salary > S1.Salary) Ex: SQL Query to find the 4th Highest Salary: SELECT * FROM SalaryTable S1 WHERE 4-1 = ( SELECT COUNT(DISTINCT(S2.Salary)) FROM SalaryTable S2 WHERE S2.Salary > S1.Salary) Option:2 SELECT * FROM SalaryTable ORDER BY Salary DESC... Continue Reading →

Android App: My Device

We all know that it is important to know and understand the features of mobile devices before we start with the app testing. But it makes it very difficult to keep track of all features. Don't worry. There is an Android app to know the end to end features of the android device. App Name:... Continue Reading →

All iOS Version list

Below is the list of IOS OS version list in Descending order. SI.no OS version 1 ios 10.3.3 2 ios 10.3.2 3 ios 10.3.1 4 iOS 10.3 5 ios 10.2.1 6 iOS 10.2 7 ios 10.1.1 8 iOS 10.1 9 ios 10.0.2 10 ios 10.0.1 11 ios 10 12 iOS 9.3 13 iOS 9.2.1 14... Continue Reading →

Powered by WordPress.com.

Up ↑