We are looking for Web Developers

Company        Tipstat Infotech Pvt. Ltd.

Website          www.tipstat.com

Eligibility        Any Graduate/PG Not Required

Experience     0-5 Years

Location         Bangalore

Tipstat Infotech Pvt. Ltd.

Job Role: Web Developer

Job Summary :

Tipstat Infotech Pvt. Ltd. is a start up Web Development Company located in Bangalore, India.

We are looking for talented Web Developers.

These are the key skills we are looking for :

1. HTML 5 and CSS 3
2. Javascript and Jquery
3. Php and Mysql
4. Wordpress
5. Joomla
6. Custom CMS

Secondary Skills (not necessary) :

1. E-commerce
2. Magento
3. Drupal
4. Adobe Photoshop

If you meet the following requirements, please contact us.

Send Your Resumes: alok@tipstat.com,contactus@tipstat.com

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