True

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 6th, 2015

TRUE..

psingla

 Profile Answers by psingla Questions by psingla

• Mar 17th, 2010

TRUEEXISTS is a SQL operatorand SOME/ANY are TSQL operators

Answer Question  Select Best Answer

I have a column in a table with names.Now i want to select that names like first name,second and third.I/p like this----- names Chandu Kannaka prasad Rama krishna Kiran kumar Kora Balaji Chandra sekhar pottaO/p I want------ Firstname Secondname Thirdname ...

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 7th, 2015

"tsql declare @Name NVarchar(MAX), @FName NVarchar(MAX), @MName NVarchar(MAX), @LName NVarchar(MAX) select @Name = SAURABH KANT CHAKRAVARTI --select @Name = SAURABH KANT s...

farhanbaig

 Profile Answers by farhanbaig Questions by farhanbaig

• Jun 7th, 2011

I am guessing you are looking for initcap function which are as follows:select initcap(first_name||' '||second_name||' '||third_name) from employees;

Answer Question  Select Best Answer

I Tried by giving......................... ALTER table table name rename column tocolumn name was changed but it's not giving entire table with altered column name.It's giving only the altered column.

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 26th, 2015

In T-SQL its not possible to rename the column name therefore use sp_rename

malapati

 Profile Answers by malapati Questions by malapati

• Oct 8th, 2008

to change name of one column   alter  table  <table name>rename column <old columnname> to <new columnname>;if we want to change more than one column  a...

Answer Question  Select Best Answer

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 26th, 2015

Since Foreign key accepts null values, then if we inset a record as NULL then how we can make Customer id as primary key in another table.

malapati

 Profile Answers by malapati Questions by malapati

• Oct 10th, 2008

A column included in the definition of referential integrity which would refer to a referenced key.? Referenced key is a primary key which is combination of UNIQUE+NOT NULL".

Answer Question  Select Best Answer

I have 2 tables. Table A and Table B. I want to display all the rows from both the tables. can anyone help me on this??

isha

• Sep 5th, 2015

UNION or UNION ALL can be used if all column names are same in both the tables... else use join condition to retrieve data from both the tables if the tables have at least one common column

YK

• Sep 4th, 2015

Use Union ALL

Answer Question  Select Best Answer

Why do we use joins, instead subquery has same operation?

laxminarayana

• Oct 16th, 2015

JOINS are used to retriveing data from more then one table.
SUBQUERIES are used to condition depends upon one data retriving from another table at the time we use subqueries.

farhan

• Oct 15th, 2015

JOINs are used where you have a complex and large queries. SubQuery is used where you have a very simple scenario and your query is not too lengthy.

Answer Question  Select Best Answer

B

irfan1patel1

 Profile Answers by irfan1patel1 Questions by irfan1patel1

• Nov 1st, 2015

B. 10

Mani Prakash Singh

• Oct 17th, 2015

10

Answer Question  Select Best Answer

What is the use Index Organized Table (IOT)?

Vishal BHOSALE

• Nov 16th, 2015

Index-organized tables have full table functionality. They support features such as constraints, triggers, LOB and object columns, partitioning, parallel operations, online reorganization, and replica...

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

How to delete duplicate records without using rownum/rowid concept?

cocoole

 Profile Answers by cocoole Questions by cocoole

• Jan 7th, 2016

Delete rowid not in (select the max rowid and group by each col {find the no duplicate table})

Answer Question  Select Best Answer

How to write a query to list the items in ascending order of Name and within Name, in descending order of Salary

vaibhav

• Jan 11th, 2016

Code
 

cocoole

 Profile Answers by cocoole Questions by cocoole

• Jan 7th, 2016

Order by name, sal desc

Answer Question  Select Best Answer

Write a query to display the employee details who joined before 5 days.

mukesh3208

 Profile Answers by mukesh3208 Questions by mukesh3208

• Jan 29th, 2016

Code
 

Muneeb

• Jan 11th, 2016

Code
 

Answer Question  Select Best Answer

I `ve 1 table with 3 colums A,B,C

A B C
1 3 5
4 null 6
8 2 null
null 1 null
null null 9
5 null 6
3 5 7
null null 3

Paurian

 Profile Answers by Paurian Questions by Paurian

• Feb 17th, 2016

A surprise to me, using CASE statements was slightly faster, and had the exact same execution plan. People would prefer this code over the SUM( ISNULL( ... ) ) answer because the intent is more clearl...

vinay

• Feb 16th, 2016

It should print out null 1 nll

Answer Question  Select Best Answer

If an implicit index is created when we create a primary key, then what is the need of explicit cursor?

shiva sai

• Feb 15th, 2016

1. Using implicit index the data can be fetched fastly only when the where clause has primary key column.

2. Explicit cursor is used when we want to fetch more than one record and also the where condition does not have primary column.

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

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

What is difference between a table and a materialised view, a view and a materialised view?

Pooja

• May 12th, 2016

Materialised views do not have the same rowid as that of the actual table wherease views have the same rowid.
Materialised views are faster because indexing can be applied since the result is stored in a db unlike view which is a logical query executed everytime.

sonali Kumari

• Jan 15th, 2016

Unlike views, however, materialized views also store the results of the query in the database. However the rowids for the table and the view are identical, indicating the view returns the exact same ...

Answer Question  Select Best Answer

Display employees who are IT_prog and salary is greater than 3000 and department is not equal to 80 and having the manager as 103

Neha

• May 26th, 2016

Code
 

Answer Question  Select Best Answer

Question: student marks stable "sp_report"
sid maths chem phy engl
1 33 45 54 48
2 55 32 50 37
3 10 20 30 40

The required o/p is (SQL QUERY TO GET THE BELOW O/P)
sid highest_marks
1 54
2 55
3 40

Paresh

• Jun 24th, 2016

Code
 

Ade

• Jun 23rd, 2016

Code
span style="color: #ff0000;">"highest_marks"

Answer Question  Select Best Answer

qptopm

 Profile Answers by qptopm Questions by qptopm

• Sep 9th, 2016

Foreign keys are both a method of ensuring data integrity and a manifestation of the relationship between tables. It is also known as referential integrity. Foreign Key is a field in database table...

shivkumarojha

 Profile Answers by shivkumarojha Questions by shivkumarojha

• Sep 6th, 2006

Disadvantages:On primary key index will be created so during updation of table index need to be adjusted accordingly. this process makes the updation slower.

Answer Question  Select Best Answer