table

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.

Question

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.

in progress 0

SQL 4 years 1 Answer 710 views Newbie

Write a query to find the record, whose join_basic is maximum using employee table.

Question

Write a query to find the record, whose join_basic is maximum using employee table.

in progress 0

SQL 4 years 1 Answer 672 views Newbie

Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.

Question

Write a query using above tables to display the Emp_no, name and Experience ( in year and month)from joining date to current date.

in progress 0

SQL 4 years 1 Answer 760 views Newbie

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

Question

Create a table Salary with the 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

in progress 1

SQL 4 years 1 Answer 976 views Newbie

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.

Question

1. Create a table employee with following Column, Constraints and Data 2. Write SQL command to add a new column state in above table and insert the state name (BR,MP,UP, JH,BR,UP)respectively.

in progress 0

SQL 4 years 1 Answer 1309 views Newbie

Register Now

Login

Lost Password

Login

Register Now

Top Categories

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.

Subscribe to our newsletter