Supplier Name
Supplier Site
Supplier Street
Supplier Contact Person
Supplier City
Supplier State
Supplier Phone number

Business requirement is : One Supplier can have multiple ( n number of
Sites ), One Supplier Site can have Multiple Contacts Persons ( n
number of Contact persons ), One Supplier Contact Person can have
multiple phone...

ashadevi21

 Profile Answers by ashadevi21 Questions by ashadevi21

• Oct 5th, 2011

Supplier Table Columns : Supplier id , supplier name (Supplier ID, supplier name as Primary Key) Supplier Site Details Columns : Supplier name , site, street, city, state (Supplier name as foreign Ke...

Answer Question  Select Best Answer

how to delete identical row from a table?

if we have 4 row and two of them having same data then how we delete identical row using delete query

Ashok Aaruu

 Profile Answers by Ashok Aaruu Questions by Ashok Aaruu

• Oct 22nd, 2011

Its not clear...... it will be execute correctly?

Siraj

• Oct 15th, 2011

Delete from table_name where rowid not in (SELECT max(rowid) FROM table_name group by (column_name))

Answer Question  Select Best Answer

How to retrieve the 2nd record from a table which has say 1000 records in it. Please answer this without using the row-id? I tried to say a query "select * from table where rowcount=1" which worked well and also "select * from table where rowcount=3" which gave me the result but not when I did the same query "select * from table where rowcount=2" ? why?

rima

• Nov 24th, 2011

Code
SELECT * FROM `table_name` WHERE rownum <> 1 ORDER BY rownum  ASC LIMIT 1; 

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 27th, 2011

The best way to issue is

select top 1 * from cars where id_car in
(select top 2 id_car from cars order by id_car)
order by id_car DESC

and with that
obtain the second record (This way is for the PK)

Answer Question  Select Best Answer

indira

• Feb 1st, 2012

Sub query: A sub query is executed once for the parent statement. Correlated Sub query: Correlated sub query runs once for each row selected by the outer query. It contains a reference to a value fr...

Answer Question  Select Best Answer

Rakesh

• Feb 7th, 2012

Normalization--To Reduce or to remove the redundancy in table we used Normalization and the normalization we can achieve by breaking of tables by this table is in Normalized.

prabu

• Jul 13th, 2011

0NF "sql CUSTOMER ORDER (CustName, OrderNo, ProdNo, ProdDesc, Qty, CustAddress, DateOrdered) 1NF - remove multivalued attributes "sql CUSTO...

Answer Question  Select Best Answer

bhagya

• Feb 10th, 2012

1.Auditing the tables
2.Online transaction
3.Securing from another table
4.Automatic calculations
5.Replicate the tables

chennoju

 Profile Answers by chennoju Questions by chennoju

• Aug 3rd, 2006

The main advantages of the triggers are* To Audit the table* To check the complex conditions which are not possible by the constraints.

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Feb 18th, 2012

Force view creates the view even if the underlying tables / referenced objects are not present. Force View are used while executing a script that has create tables and views statements or while creating a view for remote table.

Answer Question  Select Best Answer

Hi,

I have 3 files each having 2 cols
e.g
File1
empid deptid
1 100
2 200
3 200
4 100
5 300

File2
empid salary
1 10
2 20
3 30
4 40

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Mar 2nd, 2012

I believe what you are looking for is a query like this:

select f3.deptname dept_name, sum(isnull(f2.salary,0)) amt_spent_each_dept
from file3 f3 left join file1 f1 on (f3.deptid = f1.deptid)
left join file2 f2 on (f1.empid = f2.empid)
group by f3.deptname
order by f3.deptname

Answer Question  Select Best Answer

1. How to delete a duplicate records in a table without using rowid?
2. What is the use of Connect by clause?
3. What is the use of Connect by clause?
4. How to display "Experience of employee"?E.g. 3 years 4 months 19 days?
5. What is select statement to spe?

Muralidhar

• Apr 6th, 2012

We delete the duplicate records using level and rownum. The query is

Code
DELETE FROM emp WHERE ROWNUM IN(SELECT MAX(ROWNUM) FROM emp WHERE LEVEL=nth CONNECT BY PRIOR empno>empno GROUP BY LEVEL);

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Nov 28th, 2010

1 Delete from table_name where ROWID not in ( selectmax(rowid) from table group by duplicate_values_field_name);

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

nirmal1in  

 Profile Answers by nirmal1in Questions by nirmal1in

• Member Since Jan-2010 | Jan 17th, 2010

---

This can be accomplished in following way:

Example: table - emp

For First n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a < 5 --- say n is 5 display first 5 records

For last n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename) a
FROM emp) x
WHERE x.a < 5

FROM )WHERE .a<

This query can be used for finding nth row also say n = 5

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a = 5

deepthi

• May 17th, 2012

Code
SELECT rownum,a.*FROM(SELECT rownum,b.*FROM emp b ORDER BY rownum DESC) a WHERE rownum <&n;

Vasavi Katakam

 Profile Answers by Vasavi Katakam Questions by Vasavi Katakam

• Jul 18th, 2011

For First N Rows:

Code

1.  
2. SELECT top 5 * FROM table_name
3.  

For Last N Rows:

Code

1.  
2. SELECT * FROM
3. (SELECT top 5 * FROM
4. table_name
5. ORDER BY Columnname DESC)
6. ORDER BY Columnname ASC
7.  

Improve Answer

ratnam

• Aug 3rd, 2012

How write a SQL statement to query the result set and display row as columns and columns as row?

Vasanth Kumar

• Oct 6th, 2006

The simplest way to implement this in SQL 2000/OracleSelect * from table1Create a temp table with No of columns = No of rows in table 1No of rows = No of columns in table 1and insert the data into the temp table using a loop logic.

Answer Question  Select Best Answer

V.E.Rajani

• Oct 3rd, 2012

Only SELECT statement can be used in Functions. INSERT,UPDATE,DELETE are used.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Sushant

• Oct 25th, 2006

---

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.

Sameer

• Nov 1st, 2012

Now SQL SERVER 2008 onwards we can have 1 cluster index and 999 non cluster index on one table.

primarykey2000

 Profile Answers by primarykey2000 Questions by primarykey2000

• Apr 22nd, 2008

clustered index  - the index order matches the order of physically stored data.cluster index can be used on table that doent get changes frequentlyusing DML statement on cluster index column have...

Improve Answer

True

Guru

• Dec 19th, 2012

True

Durgesh Kumar Singore

• Feb 7th, 2012

In SQL 2005 only != and operator perform same operation

^= does not work

Answer Question  Select Best Answer

In a table the persons name is in lower case "abc" and is there any SQL query to obtain that persons name as "ABC" as an output?

Muzeeb

• Jan 6th, 2013

Yes, using SQL UPPER function.

Code
SELECT UPPER(name) FROM TABLE;

Answer Question  Select Best Answer

robindas

 Profile Answers by robindas Questions by robindas

• Jan 11th, 2013

Few steps for query tuning. 1) Check for if any sub query or exists or not exists is there if yes then try to change it in the joins 2) Try to check the way joins had been written try to put it in f...

samareshoracle

 Profile Answers by samareshoracle Questions by samareshoracle

• Aug 4th, 2012

Following a Tuning Methodology Objectives:: Determine performance problems Manage performance Describe tuning methodologies Identify goals for tuning Describe automatic SQL tunin...

Answer Question  Select Best Answer

Explain the normalization and why it is done. explain the case when we avoid the normalization in database.

ppad001

 Profile Answers by ppad001 Questions by ppad001

• Feb 27th, 2013

For perfomance optimization.
Like in case of datawarehousing operation the no of tables to be joined to get the desired output might be too high. In such a case we de-normalize to serve our purpose.

Answer Question  Select Best Answer

pradip

• May 26th, 2013

The primary difference between the DBMS and RDBMS we can add the foreign keys for relating the tables In dbms ,relation is between two files . while in rdbms relation is made between two tables. rdbms...

parth

• Jan 29th, 2013

Dbms does not support client/server architecture and rdbms supports client/server architecture.

Answer Question  Select Best Answer

Can we make DML operations on base tables using a simple view?Can we insert or update or delete rows to the base tables using a view?

lviswanath

 Profile Answers by lviswanath Questions by lviswanath

• Jul 22nd, 2013

Of course we can do anything i.e. updating/deleting/inserting on a base table underlying a simple view, until unless its covering NOT NULL columns of the table in the query of the simple View.

ppad001

 Profile Answers by ppad001 Questions by ppad001

• Feb 27th, 2013

Yes we can use DML operations on single table view.

Answer Question  Select Best Answer

Aria Ansari

• Nov 12th, 2013

It is about referential integrity or making data both reliable and Secure. As an example by applying a foreign key constrain between customer and order tables It will not be allowed to create an order...

Answer Question  Select Best Answer