What is basic SELECT statement?
SELECT Statement A SELECT statement retrieves data from the database. With SELECT statement PROJECTION, SELECTION and JOIN can be performed on database tables. As data in relational database is stored in TABLES. TABLE has ROW and COLUMN structure. With SELECT statement all rows and all columns can be retrieved, this is known as PROJECTION. But, if rows and columns are retrieved on the basis of some condition, it is known as SELECTION. And suppose if some information is needed and that is stored in two or more different tables but are related, use JOINS to retrieve it from two or more tables. In SQL, basic SELECT statements are as follows: SELECT * FROM [ table_name ] ; SELECT [ column1 ] , [ column2 ] , [ column3 ] , ..... FROM [ table_name ] ; SELECT and FROM are known as clauses. SELECT clause allows to specify columns to be selected from the database table. FROM clause allows to specify table name that has those column to be s
Thanks for the update admin, eagerly waiting for the next session of your blog.
ReplyDeleteQtp training in Chennai
iOS Training in Chennai
JAVA Training in Chennai
Big Data Training in Chennai
Selenium Training in Chennai
German Classes in chennai
Hadoop Training in Chennai
hadoop training
Thanks...
DeleteThis is really impressive post, I am inspired with your post, do post more blogs like this, I am waiting for your blogs.
ReplyDeleteaviation training in Chennai
air hostess academy in Chennai
Airport Management Training in Chennai
airport ground staff training courses in Chennai
Aviation Academy in Chennai
air hostess training in Chennai
airport management courses in Chennai
ground staff training in Chennai