Jagan arrest political: SC posts bail plea to May 6

New Delhi, April 29: Senior advocate Harish Salve has put forth a strong argument in the Supreme Court, saying that Y S Jaganmohan Reddy was arrested only because of political reasons.

The noted lawyer produced evidences to show that the arrest was politically motivated. He had particularly mentioned about the statement of the union minister Kotla Surya Prakasha Reddy that Jagan would get bail only if he joined the Congress party.

He argued that a central minister stating that Jagan would get bail if he joined the Congress, meant that Jagan was jailed only because he differed with the Congress and came out of it.

After hearing the arguments of Salve, the supreme court posted the case to May 6. The court also directed the CBI to file its counter by then.

Jagan's wife Bharati Reddy and auditor Vijaya Sai Reddy were present when arguments of Harish Salve were heard by the bench headed by Justice Sadasivam. It is learnt that Bharati asked the CBI officials who were present in the court, about the progress n the investigation.

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