Bir tablodan rastgele kayıt seçmek (MSSQL ve Oracle)

by nurgun 24. August 2009 23:02

Sekiz oyuncusunuz ve langırt turnuvası düzenlemeniz gerekiyor. Oyuncuları eşleştirmek için

alttaki select'i kullanabilirsiniz. 1. ve 2. oyunuc 1. takım 3. ve 4. oyuncu 2. takım ...

MSSQL

 

select * from

(select 'Umut' Oyuncu

union

select 'Özmen' Oyuncu

union

select 'Hüseyin' Oyuncu

union

select 'Mesuta' Oyuncu

union

select 'Nurgün' Oyuncu

union

select 'Şerafettin' Oyuncu

union

select 'Mesutt' Oyuncu

union

select 'Mustafa' Oyuncu

) tbl1

order by newid()

 

 

Oracle

 

select * from

(select 'Umut' Oyuncu from dual

union

select 'Özmen' Oyuncu from dual

union

select 'Hüseyin' Oyuncu from dual

union

select 'Mesuta' Oyuncu from dual

union

select 'Nurgün' Oyuncu from dual

union

select 'Şerafettin' Oyuncu from dual

union

select 'Mesutt' Oyuncu from dual

union

select 'Mustafa' Oyuncu from dual

) tbl1

order by dbms_random.value


 

Tags: , , , ,

MS SQL | Oracle

Comments

4/22/2010 8:50:23 AM #

professional digital cameras

Please tell me that youre going to keep this up!  Its so good and so important.  I cant wait to read more from you.  I just feel like you know so much and know how to make people listen to what you have to say.  This blog is just too cool to be missed.  Great stuff, really.  Please, PLEASE keep it up!

professional digital cameras United States | Reply

4/23/2010 5:48:25 AM #

memory foam mattress cover

Please tell me that youre going to keep this up!  Its so good and so important.  I cant wait to read more from you.  I just feel like you know so much and know how to make people listen to what you have to say.  This blog is just too cool to be missed.  Great stuff, really.  Please, PLEASE keep it up!

memory foam mattress cover United States | Reply

4/23/2010 9:26:09 PM #

goldy

Thanks for writing this.  I really feel as though I know so much more about this than I did before.  Your blog really brought some things to light that I never would have thought about before reading it.  You should continue this, Im sure most people would agree youve got a gift.

goldy United States | Reply

4/24/2010 5:44:03 PM #

electric fireplaces

Hello,I love reading through your blog, I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts.

electric fireplaces United States | Reply

4/25/2010 6:40:17 PM #

HGH

This is definitely a blog that people need to get behind.  The problem is, no one wants to do a great deal of reading and not have something else to stimulate the mind.  This is the internet, after all.  Maybe if you added a video or two to emphasise your point.  Ill stick around, FOR SURE.  But, I dont know if others will.

HGH United States | Reply

4/27/2010 11:27:30 PM #

Computer Games

You lost me, buddy.  I mean, I suppose I get what youre saying.  I get where youre coming from.  But you just seem to have forgotten that there are people out there who can see this issue for what it really is and may not agree with you.  You seem to alienate a whole bunch of people who might have been fans of your blog.

Computer Games United States | Reply

4/30/2010 7:32:03 PM #

Payday Cash

Good luck getting people behind this one.  Though you make some VERY fascinating points, youre going to have to do more than bring up a few things that may be different than what weve already heard.  What are trying to say here?  What do you want us to think?  It seems like you cant really get behind a unique thought.  Anyway, thats just my opinion.

Payday Cash United States | Reply

4/30/2010 7:44:17 PM #

Rapidshare

I\'m happy I found this blog, I couldnt discover any info on this subject matter prior to. I also run a site and if you want to ever serious in a little bit of guest writing for me if possible feel free to let me know, i\'m always look for people to check out my site. Please stop by and leave a comment sometime!

Rapidshare United States | Reply

5/3/2010 4:54:32 AM #

used crane

I have to say that Im really unimpressed with this.   I mean, sure, youve got some very interesting points.  But this blog is just really lacking in something.  Maybe its content, maybe its just the design.  I dont know.  But its almost like you wrote this because everybodys doing it.  No passion at all.

used crane United States | Reply

5/3/2010 6:30:26 AM #

wedding anniversary gifts

This is one of the most incredible blogs Ive read in a very long time.  The amount of information in here is stunning, like you practically wrote the book on the subject.  Your blog is great for anyone who wants to understand this subject more.  Great stuff; please keep it up!

wedding anniversary gifts United States | Reply

5/3/2010 7:26:47 PM #

acnezine acne treatment

I hate to sound like a nitpick, but your grammar is just...deplorable.  I want to be interested in this, I really do.  But it seems you spent so much time on the design (which, I will say, is amazing) that you forgot that people actually have to read your blog.  Clean this up...PLEASE.  It could be so much bigger if you just did some work.

acnezine acne treatment United States | Reply

5/3/2010 7:32:27 PM #

logistics software

Can I just say, this blog is what got me through the day today.  Every time I read it, I just get more and more excited about whats next.  Very refreshing blog and very refreshing ideas.  Im glad that I came across this when I did.  I love what youve got to say and the way you say it.

logistics software United States | Reply

5/3/2010 10:33:35 PM #

bouncy castle hire

This blog has definitely changed my perspective on this subject.  Theres no way I wouldve thought about it this way if I hadnt come across your blog.  All I was doing was cruising the web and I found your blog and all of a sudden my views have changed.  Good on you, man!

bouncy castle hire United States | Reply

5/4/2010 8:22:23 AM #

bouncy castle hire

This blog has definitely changed my perspective on this subject.  Theres no way I wouldve thought about it this way if I hadnt come across your blog.  All I was doing was cruising the web and I found your blog and all of a sudden my views have changed.  Good on you, man!

bouncy castle hire United States | Reply

5/4/2010 11:05:44 PM #

Kitesurfing Equipment

I dont know what to say.  This blog is fantastic.  Thats not really a really huge statement, but its all I could come up with after reading this.  You know so much about this subject.  So much so that you made me want to learn more about it.  Your blog is my stepping stone, my friend.  Thanks for the heads up on this subject.

Kitesurfing Equipment United States | Reply

5/7/2010 3:18:43 AM #

payday advance loan

Great concepts on this website. It's rare these days to find websites with data you are seeking. I am happy I chanced on this webpage. I will certainly bookmark it or even register for your rss feeds simply to be updated on your new posts. Keep up the nice job and I'm sure some other folks researching valued information will actually stop by and benefit from your website for resources.

payday advance loan United States | Reply

5/12/2010 7:55:45 AM #

car insurance

You sure do know what youre talking about.  Man, this blog is just great!  I cant wait to read more of what youve got to say.  Im really happy that I came across this when I did because I was really starting to get bored with the whole blogging scene.  Youve turned me around, man!

car insurance United States | Reply

5/14/2010 4:41:27 AM #

small cap investing

For what its worth, the layout is definitely amazing.  You know how to balance writing and images/videos.  However, I cant get over how little you actually bring to light here.  I think that everyones said the same thing that youve said over and over again.  Dont you think its time for something more?

small cap investing United States | Reply

5/20/2010 9:22:49 PM #

home remedies for thrush

Brilliant stuff, man!  What you have to say is really important and Im glad you took the time to share it.  What you said really spoke to me and I hope that I can learn more about this.  Thanks for sharing your opinion.  I am yet to find anything as enlightening as this on the web.

home remedies for thrush United States | Reply

5/23/2010 9:28:11 PM #

Brugge Private Jet Charter

Not many people would say this.  Youve got some guts.  I will say this, though.  If you dont want to alienate any readers, youre gonna have to stop generalising so much.  Maybe you should try seeing both sides of this issue instead of assuming that yours is the only valid opinion.  Id still read it, I like the way you write.  But I can see some people getting upset.

Brugge Private Jet Charter United States | Reply

5/27/2010 7:25:46 AM #

http://www.small-bathroom-designs.com/

Wow, what a blog!  I mean, you just have so much guts to go ahead and tell it like it is.  Youre what blogging needs, an open minded superhero who isnt afraid to tell it like it is.  This is definitely something people need to be up on.  Good luck in the future, man.

http://www.small-bathroom-designs.com/ United States | Reply

5/28/2010 7:20:38 PM #

krug baumen watches

The next time I read a blog, I hope that it doesnt disappoint me as much as this one.  I mean, I know it was my choice to read, but I actually thought youd have something interesting to say.  All I hear is a bunch of whining about something that you could fix if you werent too busy looking for attention.

krug baumen watches United States | Reply

5/29/2010 9:20:50 PM #

guru blueprint review

Sweet. Thanks for this.

guru blueprint review United States | Reply

5/30/2010 6:52:26 PM #

promote my website

Gute Idee und außerdem auch schoene Homepage.

promote my website United States | Reply

5/31/2010 8:28:27 PM #

nose hair clipper

The beauty of these blogging engines and CMS platforms is the lack of limitations and ease of manipulation that allows developers to implement rich content and 'skin' the site in such a way that with very little effort one would never notice what it is making the site tick all without limiting content and effectiveness.

nose hair clipper United States | Reply

6/3/2010 9:29:04 AM #

Life Insurance

I hope you never stop!  This is one of the best blogs Ive ever read.  Youve got some mad skill here, man.  I just hope that you dont lose your style because youre definitely one of the coolest bloggers out there.  Please keep it up because the internet needs someone like you spreading the word.

Life Insurance United States | Reply

6/7/2010 8:55:58 AM #

retail store displays

What youre saying is completely true.  I know that everybody must say the same thing, but I just think that you put it in a way that everyone can understand.  I also love the images you put in here.  They fit so well with what youre trying to say.  Im sure youll reach so many people with what youve got to say.

retail store displays United States | Reply

6/8/2010 6:56:40 PM #

discount scooter

What I want to know is why you didnt think to include the other side of this issue?  There are so many things that youre missing here that I dont see how you could actually form an intelligent opinion on the subject.  Its like you didnt even consider that there me be another side here.  Im kind of disappointed.

discount scooter United States | Reply

6/9/2010 6:49:12 AM #

Condo Mississauga

I have to say, I dont know if its the clashing colours or the bad grammar, but this blog is hideous!  I mean, I dont want to sound like a know-it-all or anything, but could you have possibly put a little bit more effort into this subject.  Its really interesting, but you dont represent it well at all, man.

Condo Mississauga United States | Reply

6/10/2010 12:41:36 PM #

car insurance quotes

This blog has definitely changed my perspective on this subject.  Theres no way I wouldve thought about it this way if I hadnt come across your blog.  All I was doing was cruising the web and I found your blog and all of a sudden my views have changed.  Good on you, man!

car insurance quotes United States | Reply

6/10/2010 8:54:33 PM #

Long reach hedge trimmer

This is good post containing some useful information. I eagerly await future posts like this

Long reach hedge trimmer United States | Reply

6/12/2010 7:47:53 AM #

autoresponders

No matter how many times I read it, it never gets old.  You definitely hit the nail on the head on this one.  This is something people need to know about.  Your blog is really incredible and the design is really top notch.  Really, youre blog is incredible.  Keep going, man.  Keep going!

autoresponders United States | Reply

6/14/2010 3:18:52 PM #

loans bad credit

This is such a deep blog!  What can I say, youve hit the nail right on the head!  You even added some videos to make it seem so much more real.  Youve got a great way of communicating with the reader, a great way of making me feel like what you have to say is just as important to me as it is to you.  Keep it up!

loans bad credit United States | Reply

6/16/2010 10:11:32 PM #

Svitlana.Net.Ua

I would like to thank you for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now.

Svitlana.Net.Ua United States | Reply

6/18/2010 6:49:16 PM #

wholesale licensed products

How could I have missed this blog!  Its incredible.  Your design is flawless, like you know exactly what to do to do make people flock to your page!  I also like the perspective you brought to this subject.  Its like you have an insight that most people havent seen before.  So great to read a blog like this.

wholesale licensed products United States | Reply

6/19/2010 6:20:17 AM #

Jack Russell Terrier Training

If I might --perhaps you should consider adding a few images.  I dont mean to disrespect what youve said; its very enlightening, indeed.  However, I think would respond to it more positively if they could be something tangible to your ideas.  Keep it up, but put a little more into it next time.

Jack Russell Terrier Training United States | Reply

6/19/2010 10:42:33 PM #

hayward pump parts

Im not gonna lie, youve lost me here.  I know that you meant well and you obviously know what youre talking about, but I cant say that I get where youre coming from.  If you want people to understand your points, you should think about the other side of the argument, too.  Youve got a wealth of knowledge, Ill give you that.  But, quite frankly, you turned me off with your tone.

hayward pump parts United States | Reply

6/20/2010 7:00:07 AM #

toronto loans

What a great idea

toronto loans United States | Reply

6/24/2010 7:37:16 AM #

Social Security Lawyer

Located a great advocate group named Freedom Disability. They can help you to apply for and win social security disabilitywith the SSA.

Social Security Lawyer United States | Reply

6/25/2010 4:10:07 AM #

Игра в Покер

I really got a kick out of your article. I don\'t really have much to say in reply, I only wanted to comment to reply with wonderful operate. good luck in 2010.

Игра в Покер United States | Reply

6/25/2010 10:59:59 AM #

ghillie suit

Thank you for this blog.  Thats all I can say.  You most definitely have made this blog into something thats eye opening and important.  You clearly know so much about the subject, youve covered so many bases.  Great stuff from this part of the internet.  Again, thank you for this blog.

ghillie suit United States | Reply

6/26/2010 7:06:27 AM #

p90x chelsea

I believed this was a genuinely interesting post and I am very glad that wrote on this subject, there are not too numerous other blogs that consider this point of view

p90x chelsea United States | Reply

6/27/2010 5:05:24 AM #

Monte Iseley

Kindly check your design and your security, sir/madam. Sorry for commenting your web page, but it will be wiser to check it first. I was checked your web site, there is any error in reading your web site, and there is navigation blur. Firstly, let me introduce myself. I work for checking as many as websites that on the internet. Many web sites has poor security and minimum update, while I checked one of them, you will be surprised that it is critical. Secondly, let talk about different topic. Your website has beautiful topic and you deliver in great order to audience. This technique is so powerful, so let me share in future post, because I am your fans of this topic. With great main topic you deliver to me, it is more important to share with us. Thanks for giving me chance to chat with you. I am pleased to welcome your future opinion.

Monte Iseley United States | Reply

6/27/2010 12:05:29 PM #

Earlene Skeet

Writing articles can give natural expression for you to express yourself, right? I am too. With new era, anyone can write their opinion in all Medias, offline and online media. We, as online writer, it is our proud to be great online writer. Internet is great for someone for giving and sharing about digital updates, lifestyle, telling new experience, comparing new products to other one, etc. I am hoping that we can be a partner in online project later. It is my introduction to give you general information about me. True readers are great, but true writers are the best. It is because you and other website creator can implement ideas and then making great media for other people, and then they can search information to be learned. I am sure that you will be fine with my comment, let me go with other opinion. With your skills in developing and writing this website, we can be a new friend, join my community and get new experience, such as future project I will do later. I will give you other message later.

Earlene Skeet United States | Reply

7/2/2010 2:05:15 AM #

computer speed up

I was wondering if you ever considered changing the layout of your blog?  Its very well written; I love what youve got to say.  But maybe you could a little more in the way of content so people could connect with it better.  Youve got an awful lot of text for only having one or two images.  Maybe you could space it out better?

computer speed up United States | Reply

7/4/2010 6:13:15 AM #

Красивые проститутки

Отдых в Сочи всегда скрасят проститутки
Мы всей компанией очень часто ездим отдыхать в Сочи. Каждый год, летом, мы отбрасываем все дела и отправляемся к морю и солнцу. Сколько я себя помню, столько мы этим и занимаемся, что самое интересно, мы всегда ездим отдыхать не в санаторий или гостиницу, а дикарем. Берем с собой палатки, набираем самую необходимую провизию и на  целый месяц отказываемся от всех благ цивилизации, что бы насладиться морем, солнцем и проститутками.

Красивые проститутки United States | Reply

7/4/2010 7:00:30 AM #

Магазин сантехники

It\\\'s an intriguing approach. I ordinarily stumble upon ordinary thoughts on the theme but yours it\\\'s written in a pretty special way. Sure enough, I will revisit your website for additional information.

Магазин сантехники United States | Reply

7/5/2010 5:27:23 AM #

credit loans

Houses and cars are not cheap and not everybody can buy it. However, home loans are created to help different people in such situations.

credit loans Canada | Reply

7/5/2010 10:09:18 PM #

handmade soap

What did you do, just say whatever it is you wanted to make people mad?!  You cant just say something like that and not give any backup for it!  Youve got to at least give me a reason to think that you know what youre talking about, otherwise, you just sound like some kid with a grudge!

handmade soap United States | Reply

7/6/2010 6:39:19 PM #

Няня

Если Вам нужна няня - смело обращайтесь в наше агентство. Не следует подавать в газету бессмысленные объявления по типу \"Нужна няня. Няня Киев). Достаточно просто прийти, обратиться к специалистам \"Светланы\" с фразой \"Ищу няню\", и можете быть уверены - спустя короткое время для Вас подберут несколько кандидатур.

Няня United States | Reply

7/7/2010 9:39:44 AM #

проститутка в Москве

I really got a kick out of your article. I don\'t really have much to say in reply, I only wanted to comment to reply with wonderful operate. good luck in 2010.

проститутка в Москве United States | Reply

7/8/2010 2:30:41 PM #

loam gal

I'm not sure I altogether agree with you on this post. Nonetheless I am definitely open to new concepts. Probably will have to think about it. Solid site incidentally.

loam gal United States | Reply

7/8/2010 4:49:38 PM #

golf clubs set

Great stuff from you, man.  Ive read your stuff before and youre just too awesome.  I love what youve got here, love what youre saying and the way you say it.  You make it entertaining and you still manage to keep it smart.  I cant wait to read more from you.  This is really a great blog.

golf clubs set United States | Reply

7/8/2010 8:14:22 PM #

Calculate Loan Payment

Hello, perhaps this post is off topic but anyhow, I have  been surfing around your site and it looks truly superb. topic and you are passionate about it. I'm making a new blog and I am hard-pressed to have it look good, and supply really good articles. I have discovered a lot on your site and I look forward to more updates and will be coming back.

Calculate Loan Payment United States | Reply

7/8/2010 10:40:04 PM #

how to get social security disability

Located a great domain named Freedom Disability. They can help you to apply for and win disability benefits with the social security administration.

how to get social security disability United States | Reply

7/9/2010 3:42:17 AM #

long term disability laws

Located a wonderful website named Freedom Disability. They can assist you to apply for and win insurance with the SSA.

long term disability laws United States | Reply

7/9/2010 1:55:47 PM #

adwords consulting

This blog has definitely changed my perspective on this subject.  Theres no way I wouldve thought about it this way if I hadnt come across your blog.  All I was doing was cruising the web and I found your blog and all of a sudden my views have changed.  Good on you, man!

adwords consulting United States | Reply

7/10/2010 5:46:13 AM #

debt recovery

Congratulations on having one of the most sophisticated blogs Ive come across in some time!  Its just incredible how much you can take away from something simply because of how visually beautiful it is.  Youve put together a great blog space --great graphics, videos, layout.  This is definitely a must-see blog!

debt recovery United States | Reply

7/10/2010 9:27:14 PM #

salon marketing course

Can I quote you in my report for school?

salon marketing course United States | Reply

7/11/2010 4:15:29 AM #

Новинки сантехники

You got numerous positive points there. I made a search on the issue and found nearly all peoples will agree with your blog.

Новинки сантехники United States | Reply

7/11/2010 5:22:59 AM #

Platinum Diamond rings

I had a blog like this once, but I had so many spam comments I had to close it. You seem to be doing a better job keeping out the spammers! Well done!

Platinum Diamond rings United States | Reply

7/11/2010 7:01:56 AM #

home loans

I took my first credit loans when I was 25 and that aided my relatives a lot. Nevertheless, I require the student loan as well.

home loans Canada | Reply

7/11/2010 8:30:28 AM #

fujitsu scansnap

I dont know what it is about this blog that turns me off so much, but you just dont seem to get me excited.  I dont know if its the lack of content or just the way you wrote it.  But you really dont seem to understand that your readers may not agree with you.  Youre really just too out there for me.

fujitsu scansnap United States | Reply

7/11/2010 8:33:09 AM #

fujitsu scansnap s308

I dont know what to say.  This is definitely one of the better blogs Ive read.  Youre so insightful, have so much real stuff to bring to the table.  I hope that more people read this and get what I got from it:  chills.  Great job and great blog.  I cant wait to read more, keep em comin!

fujitsu scansnap s308 United States | Reply

7/12/2010 3:51:58 AM #

diet for a six pack

When I primary skimmed the sales page for your publication  I've to admit I practically didn t obtain it due to the fact the copy looked slightly hyped up and pitchy  It sounded like every one of the relaxation The method has been approximately for a lot more than a decade  but belly etching has in no way truly taken off  Guerra stated  A single explanation  he thinks  is due to the fact ita  s much more well-known among guys  who tend to become from the minority of cosmetic surgery people  Youa  d also should truly  definitely want flashy abdominal muscles to go

diet for a six pack United States | Reply

7/12/2010 4:12:29 AM #

Проститутки

You gave nice ideas here. I done a research on the issue and learnt most peoples will agree with your blog. Certainly, these practices are unfair; but they say that most of their rules are only to apply to people who overdraw.

Проститутки United States | Reply

7/12/2010 7:40:45 AM #

Test

Only want to say your article is brilliant. The lucidity in your post is simply spectacular and i can assume you are an expert on this subject. Well with your permission allow me to grab your rss feed to keep up to date with future post. Thanks a million and please keep up the respectable work.

Test United States | Reply

7/14/2010 10:16:07 AM #

pennis enlargement

I just clicked over from a similar site and figured I would check things out. Really like what I see so now I'm following you. Look forward to reading your web page later on.

pennis enlargement United States | Reply

7/17/2010 8:40:56 PM #

my online business strategy review

Can I make a suggestion?  I think youve got something good here.  But what if you added a couple links to a page that backs up what youre saying?  Or maybe you could give us something to look at, something that would connect what youre saying to something tangible?  Just a suggestion.

my online business strategy review United States | Reply

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Nurgün Özgür

Facebook

 

Nurgün Özgür Photo

1993'ten bu yana profesyonel olarak yazılım ve sistem yönetimi konularında çeşitli yerli ve yabanci kuruluşların farklı kademelerinde aktif olarak yer aldım. Halen, telekomünikasyon alanında dünya lideri bir kuruluşta Software Team Manager görevimi sürdürmekteyim.

 

Valid XHTML 1.0 Transitional


Tag cloud

PagerankAlexa.Com PagerankAlexa.com