Question 1:
Employee table has 2 column eid,ename
CREATE TABLE EMP(EID NUMERIC(10),ENAME NVARCHAR(20))
INSERT INTO EMP VALUES(1,'devi')
INSERT INTO EMP VALUES(2,'TIRU')
INSERT INTO EMP VALUES(3,'Ram')
INSERT INTO EMP VALUES(4,'Saran')
What is output below query?
SELECT EID ENAME FROM EMP
OutPut:
??? Post your Answer http://jssql.blogspot.in/
This comment has been removed by the author.
ReplyDeletesir it showed the EID data with the column name of ename
Deleteya... It Display the Ename column with Eid data Sir.
DeleteVery good
ReplyDeleteOutput:
ENAME
1
2
3
4