Here I am posting some simple SQL commands. My intention is not to introduce SQL commands to the reader or make her an expert. I know these clauses are so simple & easy to remember but still I made this post so that you can do a quick revision before attending an interview.
Select command
For specifying the data which need to be displayed from a table.
Syntax:
SELECT * from tablename
SELECT columnname1, columnname2, … FROM tablename
Select command
For specifying the data which need to be displayed from a table.
Syntax:
SELECT * from tablename
SELECT columnname1, columnname2, … FROM tablename