select 1,col1,col2 from table1. output?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / senthilsjc

5 Answers
10261 Views
Ramco, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select 1,col1,col2 from table1. output?..

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

select 1,col1,col2 from table1. output?..

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

select 1,col1,col2 from table1. output?..

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

select 1,col1,col2 from table1. output?..

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

select 1,col1,col2 from table1. output?..

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

Post New Answer