Usetutoringspotscode to get 8% OFF on your first order!

  • time icon24/7 online - support@tutoringspots.com
  • phone icon1-316-444-1378 or 44-141-628-6690
  • login iconLogin

data base design and managment

o    Share what you’ve learnt. In this module, you read about querying the database by using  SELECT SQL statement.  In your own words, discuss what a query is.
o    Discuss the topic. Some data in an Employee table is shown in a picture below. Using your own words, describe what each bold and underlined keyword of the following SQL statement is for. Use the data in the table below to help with your answer. Write the data that you expect to be eliminated from the data set.  At least 150 word!!!
SELECT EmpFirst || ‘  ‘ || EmpLast AS “Employee Name”, DateAttended
FROM EMPLOYEE
WHERE Provider = “Red Cross”
ORDER BY EmpID

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes