Posts

SQL_SELECT_Statement

Image
SELECT Statement The most commonly used SQL command is SELECT statement . It is used to query the database and retrieve selected data that follow the conditions we want. In simple words, we can say that the select statement used to query or retrieve data from a table in the database. Let's see the syntax of select statement. SELECT        */list_of_cols [col-alias]/mathematical expr(s)/literals/psuedocols/functions FROM        <table 1>[table1_alias][table2 table2_alias      , .......                        ] WHERE        <condition(s)> GROUPBY col1[      , col2      , col3      , ...........]] HAVING        <condition(s)> ORDERBY col1[  ...