What is mean by TCL, What are its commands?

mallika

• Apr 26th, 2016

Transaction control language and commands are commit, rollback and save point

Anubha Bisht

• Apr 18th, 2016

Transaction Control Language

1. Commit
2. Rollback
3. SavePoint
4. Set Transaction

Answer Question  Select Best Answer

Hi,i have 1 table contain 2 column if i add a new column it default stored in last column but my recruitment adding the new column in middle of the order so can any one explain

marius

 Profile Answers by marius Questions by marius

• Dec 10th, 2015

When ALTERing TABLE ADD COLUMN NEXT TO somecolumn. :)

Shailendra

• Jun 16th, 2015

Open design view and select place where you want to insert new columns.

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

Co-related sub query is one in which inner query is evaluated only once and from that result outer query is evaluated.Nested query is one in which Inner query is evaluated for multiple times for gatting one row of that outer query.ex. Query used with IN() clause is Co-related query. Query used with = operator is Nested query

Abdul Rahman

• Jul 18th, 2017

A nested sub query is one sub query inside another sub query. A correlated sub query is a sub query that references a column from a table which appears in the parent statement.

qptopm

 Profile Answers by qptopm Questions by qptopm

• Oct 13th, 2016

Co-Related Vs Nested-SubQueries. Technical difference between Normal Sub-query and Co-related sub-query are: 1. Looping: Co-related sub-query loop under main-query; whereas nested not; therefore...

Answer Question  Select Best Answer

MONTHS_BETWEEN

Mahesh Deore

 Profile Answers by Mahesh Deore Questions by Mahesh Deore

• Mar 16th, 2011

This is the inbuilt funcion of Sql server that gives you the difference between two diffrent dates as days "dd", month "mm" and year "yyyy" also at the place of formate s...

HussainExpect

 Profile Answers by HussainExpect Questions by HussainExpect

• Nov 20th, 2008

In SQL 7.0, 2000Select days=datediff(dd,'1-1-2008','1-31-2008')Result 30 days

Answer Question  Select Best Answer

Pendo

• Jul 17th, 2021

WITH Xlist as (
SELECT salary ,rank() over( order by salary desc ) as rnk
FROM salary)
SELECT salary from Xlist where rnk =2;

Akila

• Oct 11th, 2018

SELECT *
FROM
(SELECT personid ,row_number() over (order by PersonID desc) as row_num FROM
(SELECT DISTINCT personid FROM persons))
WHERE row_num = 2

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

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

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

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

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

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

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

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

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

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

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

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