NorthStar Air Club. The club maintains a fleet of light airplanes and lets their

Question

NorthStar Air Club. The club maintains a fleet of light airplanes and lets their members fly any airplane based on the membership level. There are three types of memberships:

Basic: 40 hours a year.

Pro: 100 hours a year.

Super: 202 hours a year.

A year runs from January 1st to December 31st. Hours cannot roll over to another year. Members can join or update their membership any time: the hours will be prorated.

It has two departments:

Member services that enrolls members and collects member dues.

Scheduling that keeps track of used hours and assigns aircrafts to members.

Write a SQL query in MS SQL to show a table of Employees

Explanation / Answer

SELECT * FROM Employees;

is used where ; represents the end of the statement.

There a various methods to show a table

Follwing query is used to show entire table

syntax: SELECT * FROM TABLE_NAME;

For us we use "SELECT * FROM Employees;"

In the above syntax

* -- refers to the column names and * refers to all columns if we need we can mention only paricular columns to be viewed.

SELECT employee_id, employee_name FROM Employees;

This displays only two required columns of the table "Employees".

Even there is a "WHERE" Clause can be used to select a particular row of required

SELECT * FROM Employees WHERE employee_id=12786;

This displays all the colums of the employee id mentioned.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.