Read Best Answer

Editorial / Best Answer

Answered by: Ranjeet

• Feb 27th, 2006

---

Emp_name varchar(10) -  if you enter value less than 10 then remaining space can not be deleted. it used total 10 spaces.

Emp_name varchar2(10) - if you enter value less than 10 then remaining space is automatically deleted

Krishna Kant Kumar

• Mar 12th, 2019

VARCHAR is going to be replaced by VARCHAR2 in next version. So, Oracle suggests the use VARCHAR2 instead of VARCHAR while declaring data type. VARCHAR can store up to 2000 bytes of characters while ...

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 30th, 2018

CHARACTER Datatype: CHAR, VARCHAR both are of CHARACTER Datatype in oracle. CHAR is fixed length datatype and VARCHAR is Variable length datatype to store character data. i.e. A-Z , a-z , 0-9 and key...

Improve Answer

Display the second lowest salary from emp table without using min & all

Pendo

• Jul 17th, 2021

SELECT Top (1) Salary FROM Employee ORDER BY Salary

Code
 

satyam singh

• Apr 22nd, 2020

"HAVING" clause is required. It works with "GROUP BY" clause

Answer Question  Select Best Answer

How to retrieve a second highest salary from a table?
Note:Suppose salaries are in duplicate values
eg:
Name Sal
Malli 60000
Pandi 60000
Rudra 45000
Ravi 45000

Pankaj Yadav

• Feb 23rd, 2018

Code
 

Santhosh Kumar Gujja

• Nov 27th, 2017

SEL SAL FROM(
SEL DISTINCT SAL FROM TABLE
) O QUALIFY ROW_NUMBER() OVER(ORDER BY SAL DESC)=2

Answer Question  Select Best Answer

Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 8th, 2011

In Teradata,sel * from employee where substr(name,1,1)=substr(name,length(trim(name)),1)

Miao Lin

 Profile Answers by Miao Lin Questions by Miao Lin

• May 9th, 2011

SELECT * from employee where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);

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

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
 

Vasavi Katakam

 Profile Answers by Vasavi Katakam Questions by Vasavi Katakam

• Jul 18th, 2011

For First N Rows:

Code

1.  

For Last N Rows:

Code

1.  

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: MANAS KUMAR ROUT ( USA ) (TCS) (Eli LILLY ) - PFIZ

• Jul 6th, 2007

---

Hey Ramesh,

I understand your interviewer's enthusiasm to know about the Foreign Key.? See foreign key definitions says its states the relationship of one attribute(Column) of one table to the corresponding column on the other table.

So one os a parent and other is child. PARENT is that table which holds the primary key and CHILD is table which holds the referential key. Hence every entry in the PRIMARY table is unique where as same entry might be repeating in the child table. BUT that same has to be present in the PARENT table (Primary KEY).

Now Going by definition Foreign key can be of two types :
========================================
1.? ON DELETE SET NULL
2.? ON DELETE SET CASCADE

DETAILS:
=======
On delete set null :
=======
When a foreign key is created by on delete set null definition then when you delete one row from the primary?column (of parent table ) , then the corresponding entry in the foreign key table (Child table ) have the value "NULL" for that particular column.


ON Delete Set Cascade:
================
When the foreign key is created by this definition then when you delete the primary column (any one row -unique data) , then the Child table forcefully deletes all the rows in the child table having same value for that particular column.


I hope u got the crux of the Foreign key
Thanks
Manas Kumar Rout
SAS Consultant
Oracle Certified Associate
Unix Consultant

shweta dhumal

• Sep 8th, 2011

foreign key is primary key of other table. for example: 'STUDENT' is one table which stores information about students and 'SID' is primary key in that table and 'MARKS' is another table which stor...

shweta dhumal

• Sep 8th, 2011

The purpose of the foreign key is to ensure referential integrity of the data. In other words, only values that are supposed to appear in the database are permitted. For example, say we have two tab...

Improve Answer

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 14th, 2011

In Teradata, only one.

Pritesh Modi

 Profile Answers by Pritesh Modi Questions by Pritesh Modi

• Jun 2nd, 2011

There is only one null values accepted by a column if you assign a column as unique key constraint.thanking youpritesh

Answer Question  Select Best Answer

Not known

Abdul Rahman

• Jul 18th, 2017

Sql Server is the Database offering/ product of Microsoft. Examples of other database products are Oracle, MySql, etc. SQL is the query language that is used to handle/ manipulate data in the database...

amit

• Jun 12th, 2017

SQL is a command language to perform operations on database. SQL server in the underlying software that will accept the SQL commands given to it to perform the operations in data handled/ stored by server.
e.g. .net is language and Visual studio is software to run it.

Answer Question  Select Best Answer

Write a query to find the list of employees whos age is greater than 30 or so given a date of birth column

Shailesh Bhilare

• Dec 6th, 2021

There is a table employee (empid,empname,DOB). Get the emp count against the age bracket of less than or equal to 30 and above 30.

Could you pls give the oracle syntax for tge above Query..?

Piyush Kumar

• May 4th, 2019

Curdate() will give you the current date. here we are subtracting from dob to current date(year).

Code
 

Answer Question  Select Best Answer

When we give SELECT * FROM EMP; How does oracle respond?

Abdul Rahman

• Jul 18th, 2017

All rows from the EMP table are returned (output).

Sandip Muke

• Jul 29th, 2016

First it will do the syntax/ semantic check and if it is correct then an only that statement forward to the Oracle RDBMS server. After that Oracle will check whether that user has privilege or not. Th...

Answer Question  Select Best Answer

Given a table with 3 columns StudentName,Subject and Marks.Write a sql to retrieve second highest Marks Obtained for each student.

Zienab

• Mar 26th, 2022

Select Z.first_name, Z.last_name, Z.salary From (SELECT EMP.first_name, EMP.last_name, EMP.salary, RANK() OVER( Order by EMP.salary DESC) as Ranking FROM employees EMP ) Z Where Z.Ranking = 2;

Code
 

Rachana J K

• Jan 10th, 2022

Select student_name, marks from Student order by marks desc limit(2,1) group by sub-name;

Answer Question  Select Best 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

I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated?

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 14th, 2011

The answer by me is for teradata

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 14th, 2011

sel name,count(*) from retail.yuvagroup by 1 order by 2 having count(*) >1

Answer Question  Select Best Answer

I have table with one column. type varchar..

PHONE
---------------
99samn44423m44
8034skdf3453a2
909090abc4567d

i want to get numeric values.. i mean my output will be

PHONE
---------------
994442344
80343453a2
9090904567

thanks in advance..
Sateesh

Ganezh

• Apr 20th, 2016

Code
 

Krishna

• Mar 30th, 2016

Code
 

Answer Question  Select Best Answer

prititripathi

 Profile Answers by prititripathi Questions by prititripathi

• Oct 7th, 2011

Truncate teablename

used to delete the table

it will not update any row of the table

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Dec 28th, 2010

100turncate coomand delete all the row without deleting the colomn so 100 row updated......

Answer Question  Select Best Answer

UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;sal = 11000, comm = 1000

Madhumita

• Apr 26th, 2018

It will give
comm=1200 and sal=1000
I have executed and got the result in MySQL

souravbhattacharya1

 Profile Answers by souravbhattacharya1 Questions by souravbhattacharya1

• Aug 22nd, 2011

This Query will work fine. SQL> select * from emp where sal=10000; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO GENDER ----- ---------- --------- ----- ----------- -------...

Answer Question  Select Best Answer

Students table contains studentid, subjectid and marks. Where there are 10 subjects and 50 students. what is the Query to find out the Maximum marks obtained in each subject.

Pendo

• Jul 17th, 2021

SELECT subjectID, MAX(Marks) as Max_Mark FROM Students
GROUP BY subjectID

subh

• Apr 25th, 2020

No output display

Answer Question  Select Best Answer

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 14th, 2011

In Teradata, even if the duplicate salaries are present, below query can be used.sel b.* from (sel a.*,rank() over (order by a.salary desc) as rnk from(sel salary  from samples.empgroup by salary ) as a) bwhere b.rnk=10

rohit1505

 Profile Answers by rohit1505 Questions by rohit1505

• May 21st, 2011

SELECT *FROM emp aWHERE &n = (SELECT COUNT(DISTINCT sal))FROM empbWHERE a.emp<=b.emp);

Answer Question  Select Best Answer

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 14th, 2011

In Teradata,Select count(*) is enough.

srinadhmamidala

 Profile Answers by srinadhmamidala Questions by srinadhmamidala

• Aug 27th, 2010

SQL> select count(*) from table name;

Answer Question  Select Best Answer