Discussion :: Introduction to SQL - General Questions (Q.No.28)
|Sangeeta said: (Aug 25, 2011)|
|Srilatha said: (Aug 30, 2011)|
|Select ename, sal from emp where deptno=10;.|
|Vinay(Bml) said: (Dec 7, 2011)|
|We use select to display the table ?|
|Ayub said: (Feb 16, 2013)|
|We use SELECT to Display the DATA of COLUMN(S) Of Table..
e.g. SELECT COLUMN1,COLUMN2,COLUMN3,.....,COLUMNn from TABLENAME;
SELECT * from TABLENAME;
where * is used to show the data od ALL COLUMNS within a Table.
|Sandy said: (Sep 23, 2014)|
|Use the following:
SELECT col_1, col_2, . . . , col_n FROM table_name;
|Vedanand Singh said: (Dec 9, 2017)|
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.