Menu Bar

Home
Introduction to HTML Tables Elements and Attributes Lists Google Home Page Registration Form Forms_1 Forms_2
Introduction to CSS Three types of css Tables Forms(id,class,psuedo class) Backgrounds Periodic table Border in a table Margins and Padding Height,Width,Overflow
Introduction Basic Script Data types and Operators String methods and Arrays Functions and Objects Events Dialog boxes Conditions Loops Error Handling External JS Simple Calculator
Introduction SQL Installation and User creation SQL:Database and Table Creation SQL:Alter Constraints Select,Insert Delete Operators Functions Joins, Union, GroupBy Missing Items User Defined Functions Views Backup and Restore Company DB, Table and records Queries on Company DB Computer Business DB and Queries
Introduction Variables, Datatypes & Operators Conditional & Looping Statements Functions Pointers & Recursion Array & Files Patterns
Introduction Problems in C++
Configuration SQL server connection Introduction to PHP
Introduction VB.NET VB.NET Compilation & Run VB.NET Problems No link
Design Principles Stone Profit support page MasterLegacy MasterDev Work with Live System

Queries on Company DB

Write a query to display Department ID, Department Name, Head of the Department, No of Employee in each Department.

 Query:



Write a query to display ShiftID, no.of employees in each Shift.

 Query:



Write a query to display average salary department wise.

 Query:



Write a query to display employee list of each department where salary is less than average salary department wise.

 Query:



Write a query to display all employees with ShiftID, Time, Department Name and Head Of Department Name.

 Query:



Along with above query display employee monitor details, cpu details, head of cpu and head of monitor.

 Query:




Create a table to display Employee attendance register details and insert values.







Display the no.of employees present and absent details in a particular date.





Display a particular employee present and absent details in a particular month.





Display a particular employee salary in a month, consider all present and absent details while paying salary.







Display a particular employee salary in between two different Dates, consider all present and absent details while paying salary.






Display a particular employee salary in between two different dates without using functions.




Display a particular employee salary in between two different dates without using nested queries. Display with single statement.


Subscribe to: Posts (Atom)