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 |
what is a field in a database ? : Sql dba
what is unique key constraint? : Sql dba
Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Does indexing improve query performance?
How do I truncate a word?
how to fetch alternate records from a table? : Sql dba
Why is nosql good?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is denormalization in a database?
I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On
What is dialect in sql?