Case against Dhoni for hurting sentiments

As reported by news agency PTI, a case has been registered by a Bangalore court against Indian cricket team captain MS Dhoni for allegedly denigrating a Hindu god and hurting the religious sentiments of the Hindus. The image in question had appeared on the cover of the April 14th issue of Business Today magazine which is published by the India Today group.

Dhoni depicted as Lord Vishnu on the cover of Business Today magazine

The image appears to have been created by the magazine and it is not clear whether Dhoni posed for the photograph or if he provided his consent for the image.
Hiremath had alleged that by posing for an advertisement in a business magazine as Lord Vishnu holding several things including a shoe in his hands, Dhoni had denigrated the Hindu god and hurt religious feelings of the Hindus. Taking cognisance of the offence and registering the case, the court has posted it to May 12 for recording of the statement of the complainant.

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