Quick Links

Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?

(A) SELECT * FROM CUST WHERE last_name=’ALI’;
(B) SELECT * FROM CUST WHERE last_name=ALI;
(C) SELECT * FROM CUSTOMER WHERE name=ALI;
(D) SELECT * FROM CUSTOMER WHERE last_name=ALI;

»Important Links:

Latest Jobs in PakistanGovt Jobs in PakistanPrivate Jobs in Pakistan
NTS JobsPPSC JobsFPSC Jobs
Teaching JobsNADRA JobsBank Jobs
English McqsGeneral Knowledge McqsPak Studies Mcqs
Current Affairs McqsCurrent Affairs Mcqs PDFCurrent Affairs of Pakistan
Books PDFNotes PDFIslamic Studies Mcqs

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!