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
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answer ( 1 )
SQL> select employee.emp_no, emp_name, designation from employee, salary where basic+da-deduction=(select min(basic+da-deduction) from salary where salary_date=’30-jun-2011′);
EMP_NO EMP_NAME DESIGNATION
———- ————————————————– ————————————————–
101 Ramesh Kumar Asst. Programmner
102 Md. ALi Sr. Programmner
103 Michel Programmner
104 Amit Kumar System Analyst
105 Arshad Ali Network Administrator
106 Deepak Kumar Programmer
6 rows selected.
Attachment