Huawei Ascend G600 now available for Rs 14,990

Huawei Ascend G600 comes with a 4.5 inch qHD IPS display with Corning Gorilla Glass along with Android v4.0 OS.

Huawei's Ascend G600 is now available in India for Rs 14,999 and is currently available through Snapdeal.com. The phone is very feature rich including a 4.5 inch qHD (960 x 540 Pixels) IPS display with Corning Gorilla Glass along with Android v4.0 (Ice Cream Sandwich) OS.

The Huawei Ascend G600 has a 1.2 GHz dual core processor, 768 MB RAM, and dual DTS SRS speaker for better sound quality. The phone also has 3G, WiFi, GPS and A-GPS support.

The Huawei Ascend G600 smartphone has an 8 megapixel camera with backside illumination technology for better low light photography and dual LED flash. The smartphone comes with a healthy 1930 mAh battery as well.

The handset faces still competition from the likes of Xolo X800, Salora PowerMaxx Z1, Byond B63, and Spice Stellar Virtuoso. Though it is about Rs 3,000 costlier than most of these products, it has the benefit of better brand and hopefully that also translates into a better finished product.

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