Tuesday, August 27, 2013
Find nth Min/Max values in SQL Server
Finding Nth minimum salary:1.In SQL Server 2000/2005
SELECT salary FROM employees e1 WHERE (N = (SELECT COUNT(DISTINCT (e2.salary))
FROM employees e2 WHERE e2.salary <= e1.salary))
Finding Nth maximum salary:
1.In SQL Server 2000/2005
SELECT salary FROM employees e1 WHERE (N = (SELECT COUNT(DISTINCT (e2.salary))
FROM employees e2 WHERE e2.salary >= e1.salary))
Hope you find it useful.
Wednesday, August 7, 2013
Where is the list of pinned start menu and taskbar items stored in Windows 7
You can find pinned apps in:
%AppData%\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBarand for the start menu apps go to:
%AppData%\Roaming\Microsoft\Internet Explorer\Quick Launch\User Pinned\StartMenu
Subscribe to:
Posts
(
Atom
)