Notes
Notes - notes.io |
select*from kitap where isbnno=103
select * from kitap where isbnno = 104 or kitapAdi ='Araba Sevdası'(ikisinden biri or)
select distinct yazarNo from yazar(2 tane kağan varsa 1 tane getiriyor tekrarlayan veriler gelmez)
select yazarAd As "Yazarlar" from yazar
select(yazarAd+' '+yazarSoyad) as "AD SOYAD" from yazar
select*from kitap where isbnno=102 and sayfaSayisi>500
select*from kitap where isbnno=102 or sayfaSayisi>500
select*from yazar where not yazarAd='Orhan'(Orhan olmayanı getir)
select*from kitap order by sayfaSayisi(küçükten büyüğe sıralama)
select*from kitap order by kitapAdi ASC(a dan z ye sıralama)
select*from kitap order by kitapAdi DESC(z den a ya sıralama)
select*from yazar where yazarAd LIKE '%o%'(yazar adı içinde o olanlar)
select*from yazar where yazarAd LIKE 'r%'(isim r ile başlayanlar)
select*from yazar where yazarAd LIKE '%r'(isim r ile bitenler)
select*from yazar where yazarAd LIKE '[AS]%'(isim a ve s ile başlayanlar)
select*from yazar where yazarAd LIKE '[A-E]%'(a-e karakterleri arasında başlayan)
select*from yazar where yazarAd LIKE '_____'(5 karakter isimleri getir)
select*from yazar where yazarAd LIKE 'R____'
select*from kitap where puan in(100,90,85,75)
select*from kitap where puan between 90 and 100
select upper(yazarad) from yazar(büyük harf)
select substring(yazarAd,1,4)from yazar(1den 4 e kadar karakter al)
select right-left(yazarAd,3)from yazar(son üç harf-ilk üç harf alma)
select yazarAd,len(yazarAd) as 'Karakter Sayısı' from yazar
select replace(kitapAdi, 'Araba','Araç')from kitap
select max(vize) as'En yüksek vize notu' from öğrenci
select min(vize) as'En düşük vize notu' from öğrenci
select sum(vize) as'Toplam Vize Adedi' from öğrenci
select avg(final) as'Ortalama final notu' from ogrenci where final>=50
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
