Thursday, October 21, 2010

USB Setting

Hi friends r u feeling nervous to insert pendrives to u r PC with out u r
permission to disable USB ports just simple follow the given steps below:
Start->Run->Type =regedit
Then u can see the Registry Editor Select
HKEY_LOCAL_MACHINE->System->CurrentControlSet->Services->USBSTOR on right
side pane u can see the start option then double click on the start option
and chage the value 3 to any value above 50.

SQL : nth Max Salary

How to get nth Max salary record from employee table;

select ename from emp where sal=(select min(sal) from (select * from emp order by sal desc) where rownum<=n);

Here n denotes number, say if you need to retrieve 22nd Max salary then n=22 here.