BASIC SQL*PLUS :: DISTINCT

posted in: SQL*PLUS | 8

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>

 

 

 

 

 

 

8 Responses

  1. Darrell

    Your blog can go viral, you need some initial traffic only.
    How to get initial traffic??? Search in google for: nhuum’s seo

  2. 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

  3. 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

  4. 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.

  5. 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

  6. 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

  7. 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

Leave a Reply

Your email address will not be published. Required fields are marked *