Hi...
Im having 12 tables in a database.Record contain mobileno,place,date.
Records in one table will be duplicated in other. Wat query should i give to get unique mobileno in the whole 12 tables in the same format??
Pls help.
Thanks in advance.
Regards,
Jeen
3  1241 
Hi...
Im having 12 tables in a database.Record contain mobileno,place,date.
Records in one table will be duplicated in other. Wat query should i give to get unique mobileno in the whole 12 tables in the same format??
Pls help.
Thanks in advance.
Regards,
Jeen
Please POST what you have tried?
select *
from
select y.mobileno,y.message,y.language,y.place,y.category ,y.date,y.year
from yourTable as y INNER JOIN
(select mobileno, count(mobileno)
from yourTable
having count(mobileno)=1) as x ON y.mobileno=x.mobileno
select *
from
select y.mobileno,y.message,y.language,y.place,y.category ,y.date,y.year
from yourTable as y INNER JOIN
(select mobileno, count(mobileno)
from yourTable
having count(mobileno)=1) as x ON y.mobileno=x.mobileno
Could you please tell me if your query is working fine or not?
What is the problem you are facing in this query?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: simon.alexandre |
last post by:
Hi all,
I use csv module included in python 2.3. I use the writer and encouter the
following problem: in my output file (.csv) there is a duplication of the
end of line character, so when I open...
|
by: CJM |
last post by:
In an application I'm working the user has the opportunity to record the
despatching of one or more items with serial numbers.
For each item they despatch, they have to chose the serial no that...
|
by: Steve Jorgensen |
last post by:
A while back, I started boning up on Software Engineering best practices and
learning about Agile programming. In the process, I've become much more
committed to removing duplication in code at a...
|
by: perryche |
last post by:
Experts,
Bascially I want to avoid people entering duplicated records.
However, the check for the duplication are in 2 separate fields. i.e.
Field1 + Field2 can not be duplicated. What's the...
|
by: Tcc |
last post by:
Hi All,
Assume there are some data in "a.txt":
e.g.
ABC
|
by: ad |
last post by:
I have a string like
string myString="dog,cat,dog,tiger"
I want to delete the duplication part, and make myString to "dog,cat,tiger"
How can I do that?
|
by: =?Utf-8?B?S2F2aXRh?= |
last post by:
We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.
But only one of the users is facing...
|
by: dbarmer |
last post by:
I have a unix database system that hold three tables, 254, 255, 256, and all are linked together by WO, CUST NO, LOC NO. This is for Unix Program Purposes Only. Duplication here is by design. So...
|
by: arnuld |
last post by:
I have created a program which creates and renames files. I have
described everything in comments. All I have is the
cod-duplication. function like fopen, sprint and fwrite are being called
again...
|
by: henry |
last post by:
Folks:
Using Dreamweaver CS3...
Consider a home page, "index.php" which conditionally REQUIREs one of 'N'
HTML files of pure content. All site styles are specified in a master CSS
file,...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
