SQL query for multiple rows in single column [closed]

by

This isn’t really a good quetion and is a very likely candidate for someone down voting it.
Look here for an example schema

http://www.databaseanswers.org/data_models/patient_care/index.htm
schema

More Related Contents:

  1. Why is SELECT * considered harmful?
  2. How to check if a table exists in a given schema
  3. How do I reset a sequence in Oracle?
  4. Synchronizing client-server databases
  5. ORA-00904: invalid identifier
  6. How to create multiple one to one’s
  7. How to select unique records by SQL
  8. Fastest way to count exact number of rows in a very large table?
  9. Key value pairs in relational database
  10. T-SQL Cast versus Convert
  11. SQL – How to transpose?
  12. Splitting the string in sql server
  13. How does table alias names affect performance?
  14. Performance issue in using SELECT *? [duplicate]
  15. Need to list all triggers in SQL Server database with table name and table’s schema
  16. What is the purpose of constraint naming
  17. How can I do a BEFORE UPDATED trigger with sql server?
  18. Drop all tables command
  19. How to find a table having a specific column in postgresql
  20. Deferrable Constraints in SQL Server
  21. can we list all tables in msaccess database using sql?
  22. INSERT COMMAND :: ERROR: column “value” does not exist
  23. Comma separated values in a database field
  24. Can SQL Server Express LocalDB be connected to remotely?
  25. SQL: Using NULL values vs. default values
  26. Why don’t DBMS’s support ASSERTION
  27. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  28. Should I commit or rollback a read transaction?
  29. Why are foreign keys more used in theory than in practice?
  30. What is difference between foreign key and reference key?

Leave a Comment