SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);For Eg:-Enter value for n: 2SAL---------3700

Silpa

• Apr 18th, 2018

Select employee_id,salary, rownumber from (Select employee_id,salary,row_number() over (order by salary desc) as rownumber from hr.employees)
where rownumber = n;

VISHWA

• Mar 10th, 2018

Here for ROWNUM =1 it will work but for ROWNUM = 2 and so on it will not work.

Answer Question  Select Best Answer

How to replace only third character of employees name with * from employee table?

Ankit

• Mar 7th, 2018

SELECT REPLACE(NAME,SUBSTR(NAME,3,1),*) FROM Friend_Birthday

PAVAN

• Jan 19th, 2018

SELECT REGEXP_REPLACE(FIRSTNAME, SUBSTR(FIRSTNAME,3,1), *,1,1) FROM EMPLOYEE;

Answer Question  Select Best Answer

There is a table friends having following detailsName BirthdayJohn 28-jun-1985Peter 27-aug-1987Tom 13-aug-1986Nick 29-apr-1987Natalia 25-apr-1984Kate 28-jun-1984Wilson 11-nov-1987krish 31-jul-1987robert 25-apr-1984
SELECT names of the friends which come on the same day.. condition you don't know which birthday's repeat
SELECT...

Jonno

• Feb 1st, 2018

Code
--20180201 JL

Prabakaran

• Jul 27th, 2011

Select name from btab where bday in (select distinct bday from btab)

Answer Question  Select Best Answer

Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.

Asish

• Jan 7th, 2018

Rename: Renaming to a object.

Allows: Referring to a object to avoid the ambiguity on entity or attribute.

Pandurang

• Dec 15th, 2017

Rename is used to change the name of the table permanently.
Alias is the alternate name of the table

Answer Question  Select Best Answer

Asish

• Jan 7th, 2018

Yes, if the view is derived from one base table. Here you can execute all the DML opperation.

No, if the view derived from multiple base table.

Sushil Tembhekar

• Dec 16th, 2017

In SQL it is impossible to update the View.
but, By using "Instead of Trigger" clause in PL/ SQL, it is possible to update the View.

Answer Question  Select Best Answer

NULLNOT NULLCHECKDEFAULT

ASISH PATRO

• Jan 8th, 2018

Constraints are divided into two part
field level
Default
check
not null

column level

unique
primary
foreign

Amarjeet

• Jul 7th, 2017

NOT NULL

Answer Question  Select Best Answer

BRAHMAM

• Dec 6th, 2017

SELECT * FROM EMP E1 WHEERE N-I=(SELECT COUNT(DISTINCT SAL) FROM EMP E2 WHERE E2.SAL>E1.SAL

Ranaj KumarParida

• Jul 28th, 2017

SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL &LEVEL
CONNECT BY PRIOR SAL > SAL
GROUP BY LEVEL
ORDER BY LEVEL;

Answer Question  Select Best Answer

Papa Rao

• Oct 18th, 2017

In cross join one table of each row compare with each row another table is called Cartesian Join.

Venkatesh

• Sep 20th, 2017

If result is same, what is the use of two joins?

Answer Question  Select Best Answer

Increment the salaries by 5% and add a comm. of 300 to the existing comm, and changing the clerk to jobs of all salesman whose salary is more than or equal to 1500.

A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically defined to be mandatory must also specify the column is NOT NULL.

Read Best Answer

Editorial / Best Answer

Answered by: Vijay Raj Jaiswal

• Sep 20th, 2005

---

Hi this is modified answer ,pls post this instead of previous which i post

Primay Key                     Unique key

-----------                  ------------------

There is only one         there may be more than 1
Primary key for           Unique Key in table
1 table

It can not contain           It Can contain Null Value
Null value

Lakshmanan

• Jun 30th, 2017

Primary key is combination of not null and unique. Primary key does not insert a null value and insert value is unique. Unique is one time accepted null value and insert a data is uniquely

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

Unique key means we have to enter unique value but we can enter null.But in case of Primary key we should have to enter Unique + Not Null value in that particular column.

Improve Answer

Hi Friends, One table is there. It is having varchar2 type column and this column having both numeric and alphanumeric values but I want to retrieve only numeric related values from that table. If it is possible then say the answer plz... I will wait for ur tremendous answer...

Sayantan

• Jun 1st, 2017

Select length(trim(translate(string, +-.0123456789,) from table; if the value is null then its numeric

Atish

• Sep 13th, 2015

"oracle8 SELECT * FROM TABLE_NAME WHERE UPPER(COLUMN_NAME)=LOWER(COLUMN_NAME);Above query will give numeric values only. Matching is done on the basis of ASCII character...

Answer Question  Select Best Answer

pinky

• May 31st, 2017

SELECT * FROM (SELECT DEPT_ID , DENSE_RANK(SALARY) OVER(PARTITION BY DEPT_ID ORDER BY SALARY ) DRANK FROM DEPARTMENTS ) WHERE DRANK = 2;

KAMLESH

• Dec 29th, 2016

Code
 

Answer Question  Select Best Answer

punkaj

• May 24th, 2017

Using LISTAGG(colname) within group(order by col)

Bikesh Srivastava

• Aug 5th, 2016

use this code to seprate row value in single coulmn"mysql // Create coloumn with seprated column value.from row value SELECT DISTINCT p.[Account ID],p.[Contact ID],p.[Account Nam...

Answer Question  Select Best Answer

When will we use outer join? Explain with example

Prince raj

• May 25th, 2017

It is used to display matched as well as unmatched records from the table.
OUTERJOIN=INEERJOIN+UNMATCHED RECORD

goutham

• May 31st, 2016

Outer Join combines the Left and Right side tables

Answer Question  Select Best Answer

Maria

• May 16th, 2017

With GROUP BY statement.

Palak

• Apr 20th, 2017

By using Unique Command

Answer Question  Select Best Answer

It is a column that is not an actual column in the table.eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.

Amol Kulkarni

• Dec 3rd, 2016

Pseudo columns are used to pass additional information on a row. A pseudo column is not actually part of a row like any other columns. but exists due to the row property, they cannot be updated or mod...

qptopm

 Profile Answers by qptopm Questions by qptopm

• Nov 7th, 2016

It behaves like a table column, but is not actually stored in the table.

Answer Question  Select Best Answer

What is mean by Performance Tuning? Explain with example.

Akash S. Patil

• Nov 16th, 2016

Database tuning is a group of activities used to optimize the performance of the database. Goal of database tuning: 1. To maximize use of system resources. 2. To perform task as efficiently. 3. To wo...

Answer Question  Select Best Answer

Hi guys try this query

If any student fails in one subject also his result should be Faile r else Pass
condtion is(marks>=40 "PASS" marks

nancy

• Jul 19th, 2016

Code
 

SOnali

• Jun 29th, 2016

Select Name,
when Min(Mark)>40
Then Pass
Else Fail
End
From TableName
Group By Name

Answer Question  Select Best Answer

SQL query to replace every alternate character in a string to capital.

Input string:- govardhana
I need output as gOvArDhAnA
And vice versa i.e, GOVARDHANA and required output as GoVaRdHaNa

Provide 2 separate queries for above scenarios

Vishnu

• Jun 23rd, 2016

Code
 

Vishnu

• Jun 23rd, 2016

For Instance consider EMP Table.

Code
 

Answer Question  Select Best Answer

Sampath Kumar

• May 24th, 2016

Does Oracle 12c supports these 12 Codd Rules

aaravindkumar

 Profile Answers by aaravindkumar Questions by aaravindkumar

• Dec 13th, 2007

The only rule that is not satisfied by oracle db is the systamatic treatment of NULL values. NULL in oracle is treated as absence of a value or unknown status (in case of comparision of values) and it...

Answer Question  Select Best Answer