calculation in a simple query?

[zeeshan13]

Hi All,

I have a very simple question.

I want to select a column from a table, like this:

select NAME from employee

Just using the above column,Now i also want to have a calulation with every record (2/2) with a name 'GM' in my resultset.

I want to view my result like this:

NAME GM
tina 1
lisa 1
sara 1

How can I do this?

 

[PeterAtKangasoft]

If you want to just add a column with all ones, then you can do the following:

SELECT NAME, 1 AS GM
FROM employees

Peter Sankauskas
Web Developer

http://www.kangasoft.com/

 

[mbusa]

zeeshan bhai ! just curios why you want to do that !