select 1,col1,col2 from table1. output?
Answers were Sorted based on User's Feedback
Answer / selvaraj anna university coe
SQL> SELECT 1,emp_no,emp_name FROM emp;
1 EMP_NO EMP_NAME
--------- --------- -------------------------
1 100 SELVA
1 101 RAJ
1 102 A S KALA
1 103 JESLIN FANTA MALAR
1 104 ANITA
1 105 MURUGU
1 106 SRIVATSAN
1 107 SARABOOT
1 108 KARTHI SIR
1 109 SUDHA
1 110 MERCHI
1 111 SAVI
12 rows selected.
Is This Answer Correct ? | 28 Yes | 1 No |
Answer / chakri
Hi friend,
In the above Select statement 1 is constant so it will
display with respect to the other columns infromation
Result for ur query:
column_heading no_col col2_2 col3_3
1 name1 3000
1 name2 2000
in this way it will display the result.
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / pandian s
(No column Name) Col1 Col2
1 xx xx
1 xx xx
Note: 'xx' is nothing but Columns' actual data.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sheikbachan
hi I'M sheikbachan
select 1 col1,col2 from table
output
col1 col2
1 a
1 b
1 c
1 d
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sharmila ramuka
There will b error.Coz if we write
select 1, col2 from table1;
then its correct butthis ill gv n error.
Is This Answer Correct ? | 2 Yes | 14 No |
How do rank () and dense_rank () differ?
What are all the different types of indexes?
What is sql and its types?
What are sql indexes?
What are local and global variables and their differences?
Why use truncate instead of delete?
what is a record in a database ? : Sql dba
Which language is used in sql?
How do you use collections in procedure to return the resultset?
How does one load ebcdic data? : aql loader
What is aggregate function in sql?
Why we use cross join?