Premium Essay

Porgram

In: Computers and Technology

Submitted By arvindoscar11
Words 409
Pages 2
Nama : __________
ID_No : __________
Date : __________
Exercise 2
STUDENT
IC_no |First Name |Last Name |Gender |Address |Postal Code |Mobile Phone | |986235453 |Yap |Hui Hong |F |Cheras |81000 |019-6953666 | |A00356489 |Sofia |Abdullah |F |Klang |33000 |012-6358997 | |A02135655 |Abdul Shukor |Abdul Latif |M |Ampang |65000 |016-3677451 | |A03659874 |Melati |Manaf |F |Pandan |63100 |012-1326459 | |A16597755 |Yong |Ah Fok |M |Cheras |63400 |016-5658970 | |A18634562 |Hairi |Yaakob |M |Ampang |53110 |013-5671259 | |A19684572 |Nathan |Muthu |M |Kajang |99000 |019-3332222 | |A23568897 |Yusniza |Hassan |F |Melawati |32400 |012-6598455 | |
INSERT INTO ________ VALUES ('A03659874', 'Melati', 'Manaf', 'F', 'Pandan', '63100', '012-1326459');

INSERT INTO ________ VALUES ('A16597755', 'Yong', 'Ah Fok', 'M', 'Cheras', '63400', '016-5658970');

INSERT INTO ________ VALUES (‘A18634562', 'Hairi', 'Yaakob', 'M', 'Ampang', '53110', '013-5671259');

INSERT INTO ________ VALUES ('A19684572', 'Nathan', 'Muthu', 'M', 'Kajang', '99000', '019-3332222');

INSERT INTO ________ VALUES ('A23568897', 'Yusniza', 'Hassan', 'F', 'Melawati', '32400', '012-6598455');

Answer this following question using SQL Statement.

From table STUDENT :

Write a SQL Query to show:

1. First Name, Last Name and Address for Student that live in Ampang.

2. First Name, Last Name and Address for student’s address will start with K.

3. First Name, Last Name, Gender and Mobile Phone for female student.

4. First Name, Last Name and Numbor IC for student IC_no start with A1.

5. First Name, Last Name and Gender for male student and name will start with letter “Y”.

PROJECT
ProjectID |Project Name |Group_Name |BeginDate |EndDate | |Pjk1…...

Similar Documents

Free Essay

Kajian Dadah

...53% |264 | | |Sektor Agronomi | | | | | |4 |Bebas Dadah |7 |25 |2.56% |623 | 23 Laporan Dadah November 2012 3.4 Program Pendidikan Pencegahan Dadah – Komuniti Bebas Dadah Sebanyak 116 program pendidikan pencegahan dadah komuniti dilaksanakan pada bulan November 2012 melibatkan 21,311 orang peserta. Porgram Skuad 1Malaysia telah dilaksanakan sebanyak 94 program dengan dihadiri 54.10% belia, 23.14% dewasa dan 22.76% remaja. Selain itu, 10 program MAHABAH dilaksanakan melibatkan 2,471 orang peserta serta 10 program SMART melibatkan 410 orang peserta (Jadual 18). Jadual 18: Pelaksanaan Program Pendidikan Pencegahan Dadah - Komuniti Bebas Dadah Bagi Bulan November 2012 | | | |BIL. PESERTA | | | | | | | | | | ......

Words: 6479 - Pages: 26

Premium Essay

Human Resource Management

...UNDERGRADUATE PORGRAM IN MANAGEMENT INTERNSHIP FINAL REPORT – PRJ100 Trust consulting BY Belhassen Neili Academic year 2014-2015 1 Declaration I certify that I am the author of this project and that any assistance I received in its preparation is fully acknowledged and disclosed in this project. I have also cited any source from which I used data, ideas, or words, either quoted or paraphrased. Further, this report meets all of the rules of quotation and referencing in use at MSB, as well as adheres to the fraud policies listed in the MSB honor code. No portion of the work referred to in this study has been submitted in support of an application for another degree or qualification to this or any other university or institution of learning. Belhassen Neili Student Name Belhassen Neili Signature 10/09/2015 Date 2 Abstract During the professional internship, I discovered a new business filed that I was not interested about at the beginning, yet, after the first week, I had the passion which drives me to execute different task and learning much more about this particular filed of business. Trust consulting was the host company, situated in Nabeul, Tunisia. Though this final report, I will try to match the different activities of the enterprise and describe the way it works stating from global filed until the specific tasks of the company. Keywords: ENS, Trust consulting, technology, Business, work process 3 Table of......

Words: 7488 - Pages: 30

Premium Essay

Java

...TO CROSS CHECK  Al l Keywords is lowercased.  ‘C’ is case sensitive i.e.; “APPLE” = ‘Apple’  Keyword connect be used for any other purpose. Creating compiling & Running Program Turbo ‘c’ Editor C programming 2 Naresh i Technologies Creating a new file/Program. ALT->F->N SAVING THE PROGRAM  ALT  FS (OR) prom F2 key. 1. In the save Dialog box, create your Personal folder in the required Drive. 2. Select the created folder. 3. Name the file with .C or .CPP extension. 4. Press OK Button or Press Enter Key.  For continuous Save Press For Key LOADING AN EXISTING PROGRAM ALT F L or Press F3 Key Select the required path where you saved you file and press ok button n press enter ( Key ) COMPILING THE PORGRAM ALT C  This process includes all the library files specified and substitutes any definitions that are detected  This process creates an object file with .Obj extant and makes linking process Running the program: ALT R  This process calls the linker and associates all the memory declaration which finalized, and converts the object file to execute file, having .exe extension Compiling and Running the program: CTRL + F9  This process activates both compilation process and running process one after the other sequentially, to produce executable file TYPES OF RUNNING THE PROGRAM  SOURCE FILES  OBJECT FILES  EXECUTABLE FILES C programming .C or .CPP .Obj .exe (running) 3 Naresh i......

Words: 3176 - Pages: 13