Results 1 to 4 of 4

Thread: Difference between VIEWS and SELECT statements

  1. #1
    Geek_Guest
    Guest

    Difference between VIEWS and SELECT statements

    What's the difference between VIEWS and SELECT statements in SQL? why are we going for VIEWS instead of SELECT statements?

    Question asked by visitor Henry


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Difference between VIEWS and SELECT statements

    view is aphysical object which stores data logically.
    the main thing is view does not take space in the disc.
    you can go for either view or select statment , but if we go for a view means we are selection from a prepared / availabele list of records.


  3. #3
    Junior Member
    Join Date
    Jun 2007
    Answers
    18

    Re: Difference between VIEWS and SELECT statements

    VIEW is a virtual table by which we can create a virtual table with columns from diff tables
    It makes retrival of data from diff table lot more easier


  4. #4
    Junior Member
    Join Date
    Jan 2008
    Answers
    24

    Re: Difference between VIEWS and SELECT statements

    we know views are stored as select statement in database
    these are mainly useful to provide security to the data and to control the n/w traffic.
    in realtime views play the major role


  5.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact