fetching with SELECT

brahmanandareddy · New User Joined: 16 Dec 2004 Posts: 44 Location: Hyderabad

I have 10 columes in a table.

SELECT 1 FROM EMP WHERE EMPNO = '5012'

Does the above statement yield the result or abend?

Lkmi · New User Joined: 04 Mar 2005 Posts: 53 Location: Newyork

it neither yields u the result nor abends

Lkmi · New User Joined: 04 Mar 2005 Posts: 53 Location: Newyork

all it does is...

say, if u have 25 rows available in the EMP table where EMPNO = '5012'

then, on executing the query, 25 rows with value as 1(without any column name will be displayed...

something like this

SELECT 1 FROM table 1
WHERE country = 'ASIA'

would result in

---------+---------+---------+---------+-

---------+---------+---------+---------+-
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1 ....
25 rows.