get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)


select ename,Salary from Emp a group by Ename,Salary
   having 4=(select COUNT(distinct( salary) )from Emp b where a.salary<=b.Salary)

Comments

Post a Comment

Popular posts from this blog

Unable to add google gmail in iphone

Hello guys,                  i deleted my account and tried to add again but i was facing problem when i was entering my username and password then screen was flashing once then again go to choose option screen .  solution is you'll get micro second to save your setting . when you entered your details then screen will show save button upper right corner. then quickly press save button and you'll see your account has been added. thnx . hope it'll helpful.
Read more

Understanding ASP.NET MVC using real world example, for beginners and intermediate

Image
ASP.NET MVC First thing is to understand the ASP.NET MVC framework itself, once we’ve gotten enough understanding of the ASP.NET MVC framework, then it would be a lot easy for us to understand why ASP.NET team provided us with this framework. In web development, there are different schemes used to create web sites and web applications, which at a minor age don’t seem to cause a problem. Solving a bug might take hours of headscratching and some other help too. It is harder to find the problem that is scripted inside the HTML web page. In these scenarios, it is always found helpfull to seperate your code from your data and from your HTML markup. This would make it a lot easier to find and solve the problem. Because, now all of the code has been seperated and finding the problem at exact location won’t be a harder task. These three fields are divided and make up the MVC; Model, View and Controller pattern for web development. Actually this is not a pattern, specific to the web dev...
Read more