BASIC SQL*PLUS :: DISTINCT
এই টিউটোরিয়ালটি ডুপলিকেট রো কি ভাবে বাদ দেওয়া যায় তা শিখান হবে
বিস্তারিত ব্যাখা ::
ডেটাবেইজ টেবিলে থাকা রেকড গুলোর মধ্যে একই রেকড যদি বার বার আসে যেমন Employees table এ –ডির্পাটমেন্ট এর নাম বা জব টাইটেল এর নাম বার বার আসে যাকে আমরা ডুবলিকেট রো বলি এটি বাদ দিতে চাইলে আমরা DISTINCT ব্যবহার করতে পারি । DISTINCT ব্যবহারের মাধ্যমে আমরা ডুপলিকেট রো বাদ দিতে পারি
সিনটেক্স ::
এটি Duplicate row বাদ দেওয়ার সিনটেক্স distinct ::
SELECT DISTINCT COLUMN_NAME FROM TABLE_NAME;
শুধুমাত্র কলাম এর আগে DISTINCT লেখা লিখে দিলে DUPLICATE রেকড বাদ যাবে
উদাহরণ
এটি DISTINCT ব্যবহারের উদাহরণ
SQL> SELECT DISTINCT JOB_ID 2 FROM EMPLOYEES; JOB_ID ---------- AC_ACCOUNT AC_MGR AD_ASST AD_PRES AD_VP FI_ACCOUNT FI_MGR HR_REP IT_PROG MK_MAN MK_REP JOB_ID ---------- PR_REP PU_CLERK PU_MAN SA_MAN SA_REP SH_CLERK ST_CLERK ST_MAN 19 rows selected. SQL>
Darrell
Your blog can go viral, you need some initial traffic only.
How to get initial traffic??? Search in google for: nhuum’s seo
Jenna
I see you don’t monetize your blog, i’v got idea how to earn some
extra cash using one simple method, just search in google for;
money making ideas by Loocijano
Donna
Did you just create your new Facebook page? Do you want your page to look a little more “established”? I found a service that can help you with that. They can send organic and 100% real likes and followers to your social pages and you can try before you buy with their free trial. Their service is completely safe and they send all likes to your page naturally and over time so nobody will suspect that you bought them. Try their service for free here: http://s.beautheac.net/46
Rod
I see interesting posts here. Your site can go viral easily, you need some initial traffic only.
You should read about bucksflooder , this might interest you.
Teresa
Hi my name is Teresa and I just wanted to drop you a quick message here instead of calling you. I came to your BASIC SQL*PLUS :: DISTINCT | Oracle Bangla । World ‘s Largest database software Oracle, Oracle Bangla is the only web site to learn | বিশ্বের সর্ববৃহৎ ডেটাবেজ সফটওয়্যার ওরাকল ডেটাবেজ শিখার একমাত্র বাংলা ওয়েব সাইট page and noticed you could have a lot more hits. I have found that the key to running a successful website is making sure the visitors you are getting are interested in your website topic. There is a company that you can get keyword targeted visitors from and they let you try their service for free for 7 days. I managed to get over 300 targeted visitors to day to my website. http://hothor.se/1gj55
nba 2k17 mt
Thanks a bunch! This a very good web-site!.
nba 2k17 mt http://fietsmaatj.es/blogs/post/3957
Alisa
I was just looking at your BASIC SQL*PLUS :: DISTINCT – Oracle Bangla । World ‘s Largest database software Oracle, Oracle Bangla is the only web site to learn | বিশ্বের সর্ববৃহৎ ডেটাবেজ সফটওয়্যার ওরাকল ডেটাবেজ শিখার একমাত্র বাংলা ওয়েব সাইট site and see that your website has the potential to become very popular. I just want to tell you, In case you don’t already know… There is a website network which already has more than 16 million users, and most of the users are looking for topics like yours. By getting your website on this network you have a chance to get your site more popular than you can imagine. It is free to sign up and you can read more about it here: http://osws.uk/28m3a – Now, let me ask you… Do you need your website to be successful to maintain your way of life? Do you need targeted traffic who are interested in the services and products you offer? Are looking for exposure, to increase sales, and to quickly develop awareness for your site? If your answer is YES, you can achieve these things only if you get your website on the network I am talking about. This traffic service advertises you to thousands, while also giving you a chance to test the network before paying anything. All the popular websites are using this network to boost their readership and ad revenue! Why aren’t you? And what is better than traffic? It’s recurring traffic! That’s how running a successful website works… Here’s to your success! Find out more here: http://lis.ovh/b1 – Unsubscribe here: http://osws.uk/28m4b
JeromePoldin
I see your website needs some unique content.
Writing manually is time consuming, but there is tool for this task.
Just search for; Digitalpoilo’s tools