Scribd
Upload
28 views

Select From Candidate Where Ecode (Select Ecode From Elections Where Ecode "SAE") and State 'Bihar' and City 'Patna'

The SQL query selects all records from the candidate table where the ecode matches an ecode from the elections table for SAE and the state is Bihar and city is Patna. A second statement updates the PublicationList column for the Batch table row where BatchNo is 1 by appending ', 999' to the existing PublicationList value.

Uploaded by

sushil.singh.c
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
28 views

Select From Candidate Where Ecode (Select Ecode From Elections Where Ecode "SAE") and State 'Bihar' and City 'Patna'

The SQL query selects all records from the candidate table where the ecode matches an ecode from the elections table for SAE and the state is Bihar and city is Patna. A second statement updates the PublicationList column for the Batch table row where BatchNo is 1 by appending ', 999' to the existing PublicationList value.

Uploaded by

sushil.singh.c
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

select * from candidate where ecode=(select ecode from elections where ecode="SAE")

and state='Bihar' and city='Patna';

update Batch
set PublicationList = PublicationList + ', 999'
where BatchNo = 1;

You might also like