Anonymous hacks US Sentencing Commission, distributes files

Hacktivist group Anonymous took control of the U.S. Sentencing Commission website Friday, January 25 in a new campaign called "Operation Last Resort."
The first attack on the website was early Friday morning. The second - successful - attack came around 9pm PST that evening.
By 3am PST ussc,gov was down (it has since been dropped from the DNS), yet as of this writing the IP address (66.153.19.162) still returns the defaced site's contents.
It appears that via the U.S. government website, Anonymous had distributed encrypted government files and left a statement on the website that de-encryption keys would be
publicly released (thus releasing the as-yet unkonwn information held on the stolen files) if the U.S. government did not comply with Anonymous' ultimatum demands for legal reform.

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