How to select Specific Columns from same row in SQL Server

Question

Here is my table funcionario:

ID_funcionario  nome    numero  sexo    morada    email     data_nasc
-----------------------------------------------------------------------
1              marcio   1234    male    jardim    marcio    11/23/2017
2              joel     3333    male   bemfica     ragy     11/25/2017

I want to select specifically only the nome "marcio" and number 1234.

For example, it should appear like this:

nome    numero  
----------------
marcio  1234

This is what I tried:

select * 
from funcionario 
where nome = 'marcio' and numero = '1234';

but that just shows me the whole row like this:

ID_funcionario  nome    numero  sexo    morada    email     data_nasc
----------------------------------------------------------------------
1              marcio   1234    male    jardim    marcio    11/23/2017

marc_s · Accepted Answer · 2017-11-26 11:44:10Z

3

When you use select * ..., all the columns of the table are returned.

If you want to get only some columns, then you must be more specific, like this:

select nome, numero 
from funcionario 
where nome = 'marcio' and numero = '1234';

edited Nov 26, 2017 at 11:44

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Nov 26, 2017 at 7:37

Radu

1,03112 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Radu Over a year ago

You are welcome! If it helped, please select this as an answer (the checkmark bellow the answer) :)

Talgat · Accepted Answer · 2017-11-26 07:37:10Z

2

You are selecting every column by this: SELECT * FROM ...

try to select the columns you need by:

select nome, numero from funcionario where nome ='marcio'and numero='1234';

answered Nov 26, 2017 at 7:37

Talgat

13511 bronze badges

Comments

Cookie Monster · Accepted Answer · 2017-11-27 09:06:51Z

2

In addition to the answers above, you could also write it this way:

select nome, numero 
from funcionario 
where nome = 'marcio'

It will return your desired result as well.

answered Nov 27, 2017 at 9:06

Cookie Monster

6422 gold badges15 silver badges33 bronze badges

Comments

ElSheikh · Accepted Answer · 2018-01-17 09:05:58Z

0

SELECT * FROM [TABLENAME] WHERE Col1 = ''

or

SELECT T_Col1, T_Col2 FROM [TABLENAME] WHERE T_Col1 = ''

edited Jan 17, 2018 at 9:05

answered Nov 26, 2017 at 7:43

ElSheikh

3399 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to select Specific Columns from same row in SQL Server

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related