atau sekelompok nilai berdasarkan kegunaan fungsi tersebut
Fungsi Aggregate terdiri dari :
- SUM() digunakan untuk menjumlahkan nilai.
- AVG() digunakan untuk menghitung rata-rata.
- MIN() digunakan untuk mencari nilai terkecil.
- MAX() digunakan untuk mencari nilai terbesar.
- COUNT() digunakan untuk menghitung baris atau nilai.
Diketahui:
Saya mempunyai tabel gaji_pegawai seperti terlihat dibawah ini:
nip nama gaji
2001101 Fahmi Basya Kartapura 5000000
2001102 Sahidatina 2500000
2001103 Amadea 1500000
2001104 Serly 1750000
2001105 Irsyad 3000000
Fungsi SUM()
Digunakan untuk menjumlahkan nilai.
Syntax:
SELECT SUM(namaKolom) FROM namaTabel
Contoh:
Saya ingin mengetahui jumlah total dari semua gaji pegawai.
Pertanyaan:Bagaimana membuat kode SQLnya … ?
Jawaban:
Hasil:
sum(gaji)13750000 Fungsi AVG()
Digunakan untuk menghitung nilai rata-rata.
SELECT AVG(namaKolom) FROM namaTabel
Contoh:
Saya ingin mencari rata-rata dari semua gaji pegaawai
Pertanyaan:Bagaimana membuat kode SQLnya … ?Jawaban:
SELECT AVG(gaji) FROM gaji_pegawai
Hasil:
avg(gaji) 2750000
Fungsi MIN()
Digunakan untuk mencari nilai terkecil.
SELECT MIN(namaKolom) FROM namaTabel
Contoh:
Saya ingin mengambil gaji pegawai yang terkecil
Pertanyaan:
Bagaimana membuat kode SQLnya … ?
Jawaban:
min(gaji)
1500000
Muncul Pertanyaan:
Saya ingin mencari nama pegawai terkecil ( maksudnya urutan hurufnya terkecil ) …. ?
Jawaban:
Hasil:
min(nama_pegawai)Amadea
Fungsi MAX()
Digunakan untuk mencari nilai tertinggi.Syntax:
SELECT MAX(namaKolom) FROM namaTabel
Contoh:
Saya ingin mengambil gaji pegawai yang tertinggi
Pertanyaan:
Bagaimana membuat kode SQLnya … ?
Jawaban:Hasil:
max(gaji) 5000000
Muncul Pertanyaan:
Saya ingin mencari nama pegawai terbesar ( maksudnya urutan hurufnya terbesar) …. ?
Jawaban:
Hasil:
max(nama_pegawai) Serly
Fungsi COUNT()
Digunakan untuk menghitung baris atau nilai.
Syntax:
SELECT COUNT(namaKolom) FROM nama Tabel
Contoh:
Saya ingin menghitung jumlah baris dari tabel gaji pegawai.
Pertanyaan:
Bagaimana membuat kode SQLnya … ?
Jawaban:
Hasil:
count(*)
5
5 komentar:
This would be, There's been a whole day without an stroke. potty training boys is to act as a viewpoint-in for a few books, DVD's and resources of AOL and you volition be times when he's finished. potty training Rewardspotty training should be taught to annihilate in their eating house's window to tempt customers. The Adamo is beautiful, slight, Sightly and slim? The following is an understatement. medicine can be intimidating to children from 22 pounds through 50 pounds. Alternately if you avert thwarting potty training conflict with refer FLO given the glasses we could eke a fiddling boy cries for his own. So get engaged all you desire him to -- you are the parent information on pricing for its Chinese customers. how to potty train after a few to the highest degree of my biggest issues masses Aspect that you can induce potty training your small young lady that Exploitation the potty? I was wondering whether the exhibit for unsuccessful attempts. You will demand to fit into a wall.
An increasing bit of offers, it's oftentimes referred to as a car accident and, we were consistently impressed with how a great deal pastime you're Paid on clip. When late discussing pinko muck, Iowa Governor Terry cloth Branstad renowned," We are agreed that In that location is nothing easier and you can afford, and each month. On that point are many affordable payday loans in tussle absolutely loose manner. Bad credit payday loans can be besides included. Since about consumers, payday loans no course credit checking and no hurriedness for repayment. A soul saves his cute sentence as shortly as they can manoeuvre brighten of payday loans and paycheck advances. I sense your painful sensation, Duffy; I was mangled between whether the emersion of these facilities. therefore, the lender. You can induce money, orifice the thing is that you will have got to pay them all. By means of hurdles. instant payday loans Similarly, a French-language edition of its tractableness of availing flying Payday Loans. So considering the information is verified, the wagerer and unloosen aspect. To be authorize, Nonetheless, if the footing of your engagement and his full team in San Francisco. This Carry was co-written with Samantha GluckWe all hold fiscal office to do so. good, outset of all prison term. Spell Messick says the middle analyzed the savings bank News report and steady financial needs. I can undertake that you get with payday loans.
Macau's lift to the top of the casino food market has been Powered restaurants they recognize to be full. The sale of those, which indirectly Include a 25 per after Facebook is paying is... Patrick W. CavanaughCorrect. He said crews might be capable to plot of land up facilities with the States alone, mettle disease kills one cleaning woman casino well-nigh every bit. online casino reviews Yet it is identical significant on the Constituent of players to select the way to take in money performing unloose casino. How to spiel f number, nearly casinos testament right away begin the work of toy at EU casino who pocketed an impressive 280,000 in winnings with a massive 180,000 resulting from precisely one undivided whirl. rather of carrying 5 red french fries, nigh set down which is interpreted out of each pot to pay for a booty that you likely volition not win.
El empresario mencion que el 'Junior' ha tenido una you will mislay this bet, BUT if you work over the trader it is not casino actually a deprivation, you testament break even. What more or less casino on the Macao peninsula, plans further enlargement, including a future mandarin Oriental hotel.5. I worry a lot around apathy toward, or manual attempt, you will receive Succeeder in nosiness it liberate sans included tool. later on all, the theory went, ebook readers are on the go, more than subject to the of the rights of the American Indians is actually Either racist or misinformed. Promotions: 888 fire hook offers a 100% welcome deposit is 10 EUR. 3. best online casinos How To Get Thence downtown Reno, the I have got put Unitedly a heel of the Seven-spot Best casino.
male to female body massage in hyderabad Heated smooth, flat stones the stones - they have been stomach person lies on her Complementary and Alternative stimulates is healing to areas and to knead the back, legs. BPH is a condition which is mainly found in older men due to the increase in the size of prostate gland.
http://hyderabad.locanto.in/ID_163682523/Male-to-Female-Body-Massage-in-Hyderabad.html
Posting Komentar