Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
when u using any sql statement the following action will performed,
This is a discussion on when u using any sql statement the following action will performed, within the SQL forums, part of the Databases category; Q : when you run any sql statement the the duplicate values will be deleted perminantly how it is possible Example: empno name 1 a 1 a 1 a 1 ...
|
|||||||
09-07-2009
|
|||
|
|||
|
when u using any sql statement the following action will performed,
Q : when you run any sql statement the the duplicate values will be deleted perminantly how it is possible
Example: empno name 1 a 1 a 1 a 1 a after run any sql the output of the original table like empno name 1 a send me answer please 
|
| Sponsored Links |
|
09-07-2009
|
|||
|
|||
|
Re: when u using any sql statement the following action will performed,
Quote:
|
|
09-07-2009
|
|||
|
|||
|
Re: when u using any sql statement the following action will performed,
try this sample code in oracle
Code:
DELETE FROM duptest WHERE rowid NOT IN (SELECT max(rowid) FROM duptest GROUP BY id); link
|
|
09-09-2009
|
|||
|
|||
|
Re: when u using any sql statement the following action will performed,
Quote:
|
|
09-09-2009
|
|||
|
|||
|
Re: when u using any sql statement the following action will performed,
Hi
if you want to delete the record permanantly then u can use delete from emp where rowid not in (select max(rowid) from emp group by empno); and if you want to showing only then u can do ---select distinct(empno) from emp where empno is not null;
|
|
09-10-2009
|
|||
|
|||
|
Re: when u using any sql statement the following action will performed,
Quote:
|
|
6 Days Ago
|
|||
|
|||
|
Re: when u using any sql statement the following action will performed,
first u create a other table which have all distinct row from old table like
1)create table t2 as select distinct * from t1; thn drop old one 2)drop table t1; then rename new one 3)rename t2 to t1 i think its work
|
 |
|
«
Sql Questions For You
|
-
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| what are all testings performed in web based project | karthinb | QTP Certification | 1 | 08-11-2008 09:57 AM |
| Why we have to close connection, statement, prepared statement | Geek_Guest | Java | 8 | 02-27-2008 07:09 AM |
| Difference between Function, Copy of Action & Externel Action | Geek_Guest | QTP | 1 | 07-31-2007 07:33 AM |
| Keep track of the DML operations performed by several users | satyabrata_igate | Oracle | 2 | 07-12-2007 07:59 AM |
All times are GMT -4. The time now is 05:24 AM.
