Difference between View and table in sql

A table contains data, a view is just a SELECT statement which has been saved in the database (more or less, depending on your database).

The advantage of a view is that it can join data from several tables thus creating a new view of it. Say you have a database with salaries and you need to do some complex statistical queries on it.

Instead of sending the complex query to the database all the time, you can save the query as a view and then SELECT * FROM view

Related Posts:

  1. What is the difference between Views and Materialized Views in Oracle?
  2. What’s the best way to search for a UPC code in a Database?
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. SQL WITH clause example [duplicate]
  5. The wait operation timed out. ASP
  6. What is SELF JOIN and when would you use it? [duplicate]
  7. How do I UPDATE from a SELECT in SQL Server?
  8. SQL query to select dates between two dates
  9. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  10. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  11. Online SQL Query Syntax Checker
  12. Must declare the scalar variable
  13. Must declare the scalar variable
  14. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  15. MySQL query String contains
  16. IDENTITY_INSERT is set to OFF – How to turn it ON?
  17. How to reset AUTO_INCREMENT in MySQL
  18. mysql Foreign key constraint is incorrectly formed error
  19. Can a foreign key be NULL and/or duplicate?
  20. Why does NULL = NULL evaluate to false in SQL server
  21. How do composite indexes work?
  22. Difference between one-to-many and many-to-one relationship
  23. MySQL “WITH” clause
  24. What is the difference between JOIN and UNION?
  25. MySQL Multiple Joins in one query?
  26. Error Code: 2013. Lost connection to MySQL server during query
  27. SQL join on multiple columns in same tables
  28. Sql query – getting rid of hard-coded values
  29. ORA-00918: column ambiguously defined in SELECT *
  30. ORA-00918: column ambiguously defined in SELECT *
  31. How To Run A Github Repository?
  32. How do I format date and time on ssrs report?
  33. SQL Switch/Case in ‘where’ clause
  34. missing FROM-clause entry for table
  35. How to run a SQL query on an Excel table?
  36. MySQL Error 1264: out of range value for column
  37. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  38. How to parse XML data in SQL server table
  39. Remote table-Valued Function Calls are not allowed
  40. The backend version is not supported to design database diagrams or tables
  41. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  42. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  43. Sql query to insert datetime in SQL Server
  44. Using group by on multiple columns
  45. What is the purpose of using WHERE 1=1 in SQL statements?
  46. Exclude a column using SELECT * [except columnA] FROM tableA?
  47. How do you force mysql LIKE to be case sensitive?
  48. What is the difference between a stored procedure and a view?
  49. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  50. pg_ctl: no database directory specified and environment variable PGDATA unset
  51. ERROR 1148: The used command is not allowed with this MySQL version
  52. Bulk load data conversion error (truncation)
  53. How to order by with union in SQL?
  54. Difference between INNER JOIN and LEFT SEMI JOIN
  55. SQL conditional SELECT
  56. ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
  57. PostgreSQL create table if not exists
  58. Join vs. sub-query
  59. PostgreSQL visual interface similar to phpMyAdmin?
  60. DATEDIFF function in Oracle
  61. Solutions for INSERT OR UPDATE on SQL Server
  62. GROUP BY and COUNT using ActiveRecord
  63. MySQL – Get row number on select
  64. MySQL error: Unknown column in ‘where clause’
  65. How to truncate the text returned for a column in a MySQL query
  66. “select * into table” Will it work for inserting data into existing table
  67. ORA-01735: invalid ALTER TABLE option – Toad
  68. CASE IN statement with multiple values
  69. List of special characters for SQL LIKE clause
  70. Use wpdb->prepare for `order by` column name
  71. How To Write An Inner Join With WP Query
  72. Cron While Editing Post
  73. Update user_login, user_nicename, and display_name
  74. Change sticky status of posts from phpMyAdmin
  75. How to import a Typo3 database to a wordpress site?
  76. find pods item where relationship to other pod is not set
  77. Export SQL query based on post type
  78. Convert a category of posts to a custom post type using (MySQL) queries
  79. Connect to Ms SQL Server
  80. Clean up very big and very dirty database
  81. wpdb prepare sql problem
  82. How can I convert everything from category X to have post format Link
  83. Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
  84. REGEXP_REPLACE in post_contet
  85. Bulk delete WordPress Post and all metadata, etc using SQL query
  86. Menu Order updating automatically
  87. How delete post_content records of specific category from phpmyadmin
  88. Reset post IDs with all post meta
  89. Fastest way to display 5000 post titles?
  90. How to Add or Change Post Title
  91. Why does DROP TABLE-ing the `wp_options` reset my user session?
  92. How do I display SQL query on a specific page of my wordpress site
  93. How to refactor DB queries for better TTFB in WordPress?
  94. query sql-table and change entities
  95. Is it possible to utilize custom SQL for a single-post.php?
  96. How to handle my row actions on a custom list table in the admin section
  97. Analog category_and (WP) in sql query
  98. Backtick (MySQL norm) added to SQL Server Query causing error
  99. How can I avoid duplicate primary keys in SQL import?
  100. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1

Leave a Comment