What is difference b/w coreleated subquery and nested subquery?

pradeep

• Nov 21st, 2013

A outer query out put is input of inner query

Vikas

• Jul 31st, 2013

Co-related sub query give reference to outer main query but nested sub query will have independent result set to be passed to outer query.

Answer Question  Select Best Answer

DEPARTMENT_ID ,EMP_COUNT, DEPT_PERCENTAGE

VIBHAV MISHRA

• Jun 30th, 2014

Update

Answer Question  Select Best Answer

sweety

• Aug 23rd, 2014

Denormalization is done to increase query performance and
normalization is done to reduce data redundancy

Bhoomika sharma

 Profile Answers by Bhoomika sharma Questions by Bhoomika sharma

• Dec 16th, 2008

To increase the query performance thus demoralization is done.

Answer Question  Select Best Answer

What is sql query to retrieve the second effective employees from job data for all the employees?

sathis raja

• Sep 11th, 2014

We can get 2nd maximum salary of the employees.

VIBHAV MISHRA

• Jun 30th, 2014

Select max(Sal) from Emp Where Sal not in(Select max(Sal) from Emp)

Answer Question  Select Best Answer

Which type of binding does PL/SQL use?

kanhaiya

• Oct 9th, 2014

Early binding

Answer Question  Select Best Answer

I want to add a new column in our table and i already have 4 column in table i want that my column should be added at 3rd position not in last position ..

S. Venmathi

• Jan 5th, 2015

if we are a Admin there is some possible. As my thought, it is not possible. but we can change the order of the column when we show the table. Example, consider your your fourth column is last_name, w...

Answer Question  Select Best Answer

Elango

• Jan 23rd, 2015

PL/SQL packages are schema objects that groups logically related PL/SQL types, variables and subprograms. A package will have two mandatory parts: Package specification Package body or defi...

Answer Question  Select Best Answer

Nilesh Rathod

• Mar 17th, 2015

Simply using group by and Having clause.

Code
 

Nilesh Rathod

• Mar 17th, 2015

Simply Using group by and having clause...

Code
 

Answer Question  Select Best Answer

If i have two table T1 having data of column C1,C2,C3 and C4 and T2 having data of column C5,C6,C7 and C8,How to copy Data of T2 to T1 or T1 to T2

Aakash

• Mar 22nd, 2015

INSERT INTO T1
(
SELECT
C5,
C6,
C7,
C8
FROM T2)

smamish

 Profile Answers by smamish Questions by smamish

• Mar 22nd, 2015

Code
 

Answer Question  Select Best Answer

Sivaprasad

• Apr 1st, 2015

Select ename,Sal from emp
where rownum < 10 minus Select ename,Sal from emp
where rownum < 9

ashadevi21

 Profile Answers by ashadevi21 Questions by ashadevi21

• Sep 27th, 2011

SELECT * FROM store_chr_val WHERE ROWNUM

Answer Question  Select Best Answer

kamlesh mishra

• May 18th, 2015

Default type of index is B-Tree - usually created when the column have more distinct or unique values like emp_no. When column have sequential values e.g 111,112,113,114 then use reverse key index wh...

Answer Question  Select Best Answer

Binod

• May 26th, 2015

SELECT MIN(SALARY) FROM
(SELECT DISTINCT SALARY FROM EMPLOYEE
ORDER BY SALARY DESC)
WHERE ROWNUM

Nikita Patil

• Jan 11th, 2015

SELECT ENAME FROM (SELECT * FROM EMP ORDER BY SAL DESC )
WHERE ROWNUM

Answer Question  Select Best Answer

Avanish Kumar

• May 26th, 2015

Rename table old_tablename to new_tablename

Neeru Nagi

• May 20th, 2015

In Sql_Server,

SP_RENAME old_table_name, new_table_name

Answer Question  Select Best Answer

I have following table as books101 BOOK_NO BOOK_NAME AUTHOR_NAME COST CATEGORY1234 C Dennis 450 System1235 Oracle Loni 550 Database1236 Sql Loni 250 Database1237 Pl/Sql Scott 750 Database Now I want to List all the authors and book name that has more then 1 book written by them.pls help

Pravalika

• Jul 2nd, 2015

Code
 

Avinash

• Jun 24th, 2012

Select AUTHOR_NAME,BOOK_NAME from books101
where AUTHOR_NAME in
(select author_name from books101 group by author_name having count(*)>1);

Answer Question  Select Best Answer

Vipin

• Jul 7th, 2015

It is always a good practice to create a Clustered Index on the Primary key and make sure that the Primary key is sequential. A table can have only one clustered index where as a table can have unlimi...

saira banu

• Jun 10th, 2015

Table

Answer Question  Select Best Answer

Janmejay Rout

• Jul 13th, 2015

Hi,
You can create 12 triggers on a table.

indira_priyadarsini

 Profile Answers by indira_priyadarsini Questions by indira_priyadarsini

• Jul 29th, 2009

Only 3 triggers can be created on a table. i.e (Insert,Update & Delete)and Maximum of 1024 columns can be created in a table.

Answer Question  Select Best Answer

abid

• Jul 30th, 2015

ALTER USER ABC IDENTIFIED BY XYZ; if user does not exist it will create user

laxmi

• Apr 28th, 2015

Yes, create user identify by
Its created by DBA

Answer Question  Select Best Answer

I have a table with 20 columns and I have to retrieve 19 except one.
Is there any way easier then giving
SELECT Col1,Col2,Col3,..........Col19 from table1.

dan

• Jul 31st, 2015

No, cant be done.

bhanu

• Nov 23rd, 2011

If we are dong select top 33* from table, we will get topmost 33 records but not the all 33 columns except 1 column in a table.

Answer Question  Select Best Answer

My Question is :

I have one table , from this table I have 1000 records. Particularly I need retrieve the 5th record only.
no need retrieve 1 to 4th only 5th record only I need retrieve by using SQL Query?

dan

• Jul 31st, 2015

Such requirement is fundamentally incorrect. Yes, such a need might arise when data from a non-RDBMS source has been imported into a RDBMS. If some one forethought should be given to identifying the ...

pravalika

• Jul 2nd, 2015

Code
 

Answer Question  Select Best Answer

I have table .. like

EMPNO Ename DOB
------------------------------------
1 you 1-jan-2011
2 Me 28-jan-2011

tel me the query for no.of days different from.. two dates of column DOB.?

Thanks in advance.
Sateesh

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 2nd, 2015

Code
 

kirathakudu

 Profile Answers by kirathakudu Questions by kirathakudu

• Dec 13th, 2011

Select date1-date2 from tablename;

If the above value is negative it means date 1 is older than date 2

Answer Question  Select Best Answer