Username*
E-Mail*
Password*
Confirm Password*
Terms* By registering, you agree to the terms of service and Privacy Policy.
Forget
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Write a query using above tables to find the employee no, name, designation, whose net salary(basic+DA-Deduction) is minimum in the month of June 2011.
Write a query to find the record, whose join_basic is maximum using employee table.
Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.
Create a table Salary with following column and data and Write a query using above tables to display the Emp_no, name and net salary of each employee of a particular month
Create a table employee with following Column, Constraints and Data and Write SQL command to add a new column state in above table and insert the state name (BR,MP,UP, JH,BR,UP)respectively.