How to delete duplicate records without using rownum/rowid concept?

cocoole

 Profile Answers by cocoole Questions by cocoole

• Jan 7th, 2016

Delete rowid not in (select the max rowid and group by each col {find the no duplicate table})

Answer Question  Select Best Answer

If an implicit index is created when we create a primary key, then what is the need of explicit cursor?

shiva sai

• Feb 15th, 2016

1. Using implicit index the data can be fetched fastly only when the where clause has primary key column.

2. Explicit cursor is used when we want to fetch more than one record and also the where condition does not have primary column.

Answer Question  Select Best Answer

Display employees who are IT_prog and salary is greater than 3000 and department is not equal to 80 and having the manager as 103

Neha

• May 26th, 2016

Code
 

Answer Question  Select Best Answer

Compose an SQL statement to show a list of two least expensive vendors (suppliers) for each raw material. In the result table, show Material ID, Material Description, Vendor ID, Vendor Name, and Supplier’s unit price. Sort the result table by Material_ID and unit price in ascending order. Note: if a raw material has only one supplier(vendor), that vendor should also be in the result (output) table...

shirley

• Apr 26th, 2017

"sql SELECT Rank() OVER (PARTITION BY MaterialID ORDER BY UnitPrice ASC) AS [Ranking], MaterialID, Description, VendorID, VendorName, UnitPrice INTO tempdb..ProductByVendor FROM ...

Answer Question  Select Best Answer

Describe use of VIEW in SQL Server?

Krishnaveni

• Aug 10th, 2018

A view is virtual table created using the real table. End users can easily access the data with out altering any table definition by using views. We can create, replace or drop the view depending on ...

Answer Question  Select Best Answer

DROP TABLE &TABLE_NAME;Variable names should start with an alphabet. Here the table name starts with an '&' symbol.

Poonam Sachdeva

• Nov 23rd, 2005

This does not give an error in Oracle 9iFollowing is the outputSQL> DROP TABLE &TABLE_NAME;Enter value for table_name: temp_special_payslip(this has been eneterd by me)old   1: DROP TABLE &TABLE_NAMEnew   1: DROP TABLE temp_special_payslipTable dropped.

naveen

• Sep 19th, 2005

this works in oracle9i and it will ask for table nameand the given table will be deleted

Answer Question  Select Best Answer

It is used to drop constraints specified on the table.

chitra

• Nov 14th, 2005

The rtrim function requires 1 arguments.

Anuradha

• Oct 13th, 2005

Ans:The given answer says the use of DROP command.but not the drop option in the ALTER TABLE command.       Drop option in the ALTER TABLE command is uesd to drop columns...

Answer Question  Select Best Answer

FLOOR

Tushar

• May 9th, 2007

TRUNC will give same output as FLOOR

sahu

 Profile Answers by sahu Questions by sahu

• Jan 27th, 2006

Ans:Yes ,we can find the largest integer less than or equal to a specific valueFLOOR

Answer Question  Select Best Answer

er.prateek.cs

 Profile Answers by er.prateek.cs Questions by er.prateek.cs

• May 28th, 2010

c>LIKE   LIKE%% with wildcards used for searching

kranti

• Jul 28th, 2005

LIKE

Answer Question  Select Best Answer

How do I write a cron which will run a SQL query and mail the results to a group?

Kwisatz_Haderach

 Profile Answers by Kwisatz_Haderach Questions by Kwisatz_Haderach

• Feb 1st, 2011

Create sql file name_of_file.sqlIn name_of_file.sql file output to pipe 'mailx -s "SUBJECT"  mail_recepient' select * from table;Create a unix script name  "whatever&q...

Kalyan

• Oct 18th, 2005

Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results throught email.

Answer Question  Select Best Answer

Tushar

• May 9th, 2007

Use Export and Import tools for backups and restore resp.you can use exp and imp as well

shuaib

• Nov 11th, 2005

U can backup the sql files through backup utilities or some backup command in sql . SAP is ERP software for the organization to integrate the software .

Answer Question  Select Best Answer

naveen_vangapalli1

• May 26th, 2007

The select statement goes to oracle server and the server responds

shashi

• Oct 25th, 2005

First it will look into the System Global Area (SGA) weather the query is been exectued earlier.If it exist, it would retrive the same output present in memory.If not the query we typed...

Answer Question  Select Best Answer

gunjan28

 Profile Answers by gunjan28 Questions by gunjan28

• Nov 11th, 2009

When using a count(distinct) it is better to use self-joinExp- in employees table to get manager name and total employees including manager querry will be-id first_name last_name m...

Sujatha

• Aug 1st, 2006

Hi All,Instead of this we can use GROUP BY Clause with HAVING condition.For ex,Select count(*),lastname from tblUsers group by lastname having count(*)>1This query return the duplicated lastnames values in the lastname column from tblUsers table.

Answer Question  Select Best Answer

Please give some sub-query examples based on correlated sub-query and nested

Pallavi g rao

 Profile Answers by Pallavi g rao Questions by Pallavi g rao

• Apr 21st, 2011

correlated:- outer query is executed first and result is sent to inner query for execution       select * from emp e1 where e1.basicsal=(selcte max(basicsal) from emp e2 ...

nandlalseth

 Profile Answers by nandlalseth Questions by nandlalseth

• Aug 14th, 2008

Correlated Sub Query:Select * from emp e where exists (select 1 from dept d where d.deptno?= e.deptno)Nested Sub Query:Select * from emp e where deptno in (select deptno from dept d)

Answer Question  Select Best Answer

Can any one guide me how can i import and export schema using SQL and OEM

Shaik Kareem

 Profile Answers by Shaik Kareem Questions by Shaik Kareem

• Jun 6th, 2011

Exp file=fullprd.dmp logfile=fullprd.log full=y

luzaolai

 Profile Answers by luzaolai Questions by luzaolai

• Apr 27th, 2009

In db2 three different format (ixf,del,asc) to export data:Export to tablename.ixf of ixf select * from tablename. When do import we can define if the original data should be kept or cleaned. Insert ...

Answer Question  Select Best Answer

IS NULL operator

burelamanohar

• Feb 6th, 2007

Null Operator

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 8th, 2006

  select * from table1 where colunm1 IS NULL;This statement will suffice.

Answer Question  Select Best Answer

START <filename> or @<filename>

Lavanya Chowdary

• May 6th, 2007

@

Anshul

• Oct 17th, 2005

START

Answer Question  Select Best Answer

&

malapati

 Profile Answers by malapati Questions by malapati

• Oct 11th, 2008

& (ampresend) symbol is used with insert command.

Anuradha

• Oct 13th, 2005

Ans :insert into .Because  & is used for substitution variables . And INSERT INTO command is certainly not used before a substitution variable.

Answer Question  Select Best Answer

Insert, update, delete, select, references, index, execute, alter, all

carlc40

 Profile Answers by carlc40 Questions by carlc40

• Apr 22nd, 2010

Oracle perspective -It depends on whether the user owns the table and if that user has the ADMIN privilege to grant privileges to others.?

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 8th, 2006

Alter, delete, index, insert, references, select, update.  are the table(object)priviliges that can be granted by a user to others.

Answer Question  Select Best Answer

B

LakshumaiahGoud

 Profile Answers by LakshumaiahGoud Questions by LakshumaiahGoud

• Oct 3rd, 2010

it will print two times.if n fork calls then no.of processes will be 2^n

Bhoomika sharma

 Profile Answers by Bhoomika sharma Questions by Bhoomika sharma

• Dec 16th, 2008

The answer is B as:the fork() calls the function i.e.it makes a copy of the parent process in the form of a child process. Thus,the two calls will be made to the function and as a result HEllo World is printed as twice and thus the answer.

Answer Question  Select Best Answer