PostgreSQL Query tuning up

Question

I am looking to tune up my query.

SELECT student_id,net_id
FROM nstudent
WHERE status_id=3
INNER JOIN ndepart using (net_id)
WHERE NOT deleted;

The above query shows the result but i also want to get the depart_name which is ndepart table, but i cannot figure out how would i do it (probably in descending order)?

Types

student_id,net_id are bigint.
depart_name is character
status_id is integer.

FK/PK's

net_id is primary key for ndepart
foreign key in nstudent and student_id is primary key for nstudent.

Thank you

Do not create multiple copies of same question. The previous question had comments about the improvement you needed to do to get an answer. — Ihor Romanchenko
– Ihor Romanchenko, Commented Oct 17, 2013 at 13:44

bma · Accepted Answer · 2013-10-17 15:08:45Z

1

SELECT S.student_id, S.net_id, D.depart_name
FROM nstudent S
INNER JOIN ndepart D ON S.net_id = D.net_id 
WHERE s.status_id = 3
AND NOT d.deleted;

edited Oct 17, 2013 at 15:08

bma

9,8362 gold badges35 silver badges22 bronze badges

answered Oct 17, 2013 at 12:55

user2869880

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

Collectives™ on Stack Overflow

PostgreSQL Query tuning up

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related