Question

Explain how the SELECT and WHERE commands help a user to view the necessary data from...

Explain how the SELECT and WHERE commands help a user to view the necessary data from multiple database files (tables).

0 0
Add a comment Improve this question Transcribed image text
Answer #1

ANSWER:

As per the given question

SELECT Statement The SELECT statement is used for retrieving the required attributes or all data from one or more tables in dConsider the following two tables: Employee table: Employee_ID Employee_Name DeptNo 34218 Johnson 100 45079 Wilson 100 34532Department table: DeptNo DName Loc 100 Sales London 200 Accounts USA 300 Computers India Suppose the user need to know the emQuery: SELECT Employee_ID, Employee_Name FROM Employee Output: Employee_ID Employee_Name 34218 Johnson 45079 Wilson 34532 DarSuppose the user need to know the employee id, employee name of employees who work in department 100. The data can be retrievSuppose the user need to know the employee id, employee name, department name and location of the department of employees who

Thank you for question......kindly rate ......its helps me a lot

Add a comment
Know the answer?
Add Answer to:
Explain how the SELECT and WHERE commands help a user to view the necessary data from...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT