Tanong -- RE: sql query in pgadmin

[Racer_X]

guys tanong ko lnag po kung ano po query pede gamitin . .. if gusto ko po makita yung laman ng isang field from a table ..

sana po matulungan nyu po ako . .

salamat po ng marami .

baguhan lang po . .nag search po ako kasu waala ako makita ..

 

[masterA2Z]

Use the ff command: select <column> from <table> <where condition = value> . Yung <where condition = value> ay optional, just for filtering.

e.g.

a. list all grades in the student table
select grade from studentTbl;

b. list grade of student with name that is 'abc' in the student table
select grade from studentTbl where name = 'abc';

c. list all columns and their value in the student table
select * from studentTbl;

HTH

 

[Racer_X]

Use the ff command: select <column> from <table> <where condition = value> . Yung <where condition = value> ay optional, just for filtering.

e.g.

a. list all grades in the student table
select grade from studentTbl;

b. list grade of student with name that is 'abc' in the student table
select grade from studentTbl where name = 'abc';

c. list all columns and their value in the student table
select * from studentTbl;

HTH

salamat po ng marami . gets ko na po