SQL - how to get specific value of cell?

Question

Fist time using SQL and already confused. I have a table :

A  |  B
--------
a  | 6
b  | 10
c  | 12

I want to filter it by using string comparison, but getting the value of the second column :

myNum = SELECT B WHERE A ='a'

At the end I want the value of myNum to be 6.

Just can't get it right... any help would be very appreciated!

Answer 1

You need to specify table name.

SELECT B from table_name WHERE A = 'a';