Simple tip on Cleaning the USB antivirus by Command Prompt

USB are very well used in the computers now a days , but due to this Viruses are easily entering the computer.

When you do not have any Anti-Virus in the System, it is difficult to remove the Virus and we forced to remove the USB without our Use

An simple trick for Deleting the Anti-Virus by the Command Prompt.Please follow Carefully......

1) Go to Start

2) Then Type cmd and hit enter

3) Then Type C: and hit Enter

4) Then type autorun.inf and hit enter

5) Then Type del autorun.inf and hit enter

6) now type attrib autorun.inf -s -h -r and press enter

7) Now delete each infected file by their name e.g ( del filename )

8) Here you are going on Autorun.inf so type del autorun.inf and press enter

7) Now the USB is free from the Virus...........

How to find out Max Salary from each department

You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SQL Query: SELECT DeptID, MAX(Salary) FROM Employee GROUP BY DeptID. This questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case you need to join Employee table with Department using foreign key DeptID, make sure you do LEFT or RIGHT OUTER JOIN to include departments without any employee as well. Here is the query

List the emps who joined before 1981.

Answer: select * from emp where hiredate < (’01-jan-81’);

SQL Info

Search This Blog