There is three tables Customer, order and order details.
Customer and order linked with cust_id, order and order_details connected with order_id.
How a column(total_order) in customer to be updated from order_details.

How can i retrieve uncommon fields from two different tables along with the data??? say i have table A and table B and Tbl A has x,y,z fields and Tbl B has x,a,b fields and i have to retrieve y,z,a,b fields from two tables along with the data.

Divya

• Jun 5th, 2017

You can try below example query using the 2columns in this query : Select ContactName,FirstName from Customers C, Employees E where C.ContactName not in( E.FirstName)

Ade

• Jun 27th, 2016

Code
 

Answer Question  Select Best Answer

I have a source table with one column of 15 characters and I want output like divide the 15 chars column into multiple of 3 columns like every column 5 chars

source empnoorderprdct target empno order prdct

Divya

• Jun 5th, 2017

You can use Substring function to split the column values to 3 columns

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Jul 12th, 2016

Please use MID() function to extract characters from a field.

Code
 

Answer Question  Select Best Answer

Compose an SQL statement to show a list of two least expensive vendors (suppliers) for each raw material. In the result table, show Material ID, Material Description, Vendor ID, Vendor Name, and Supplier’s unit price. Sort the result table by Material_ID and unit price in ascending order. Note: if a raw material has only one supplier(vendor), that vendor should also be in the result (output) table...

shirley

• Apr 26th, 2017

"sql SELECT Rank() OVER (PARTITION BY MaterialID ORDER BY UnitPrice ASC) AS [Ranking], MaterialID, Description, VendorID, VendorName, UnitPrice INTO tempdb..ProductByVendor FROM ...

Answer Question  Select Best Answer

I have a scenario like Have 7 tables. All these 7 tables have same metadata structure and also all have 2 columns. In that, One column is same in all 7 tables (Joining column, But not a primary column) and another column has different values.

Below have a example for 2 tables. How can we achieve for 7 tables?

Tab1
====
loc_name mem_name
HYD ...

Tmas

• Nov 3rd, 2016

Use outer join

Code
 

Pavan

• Oct 1st, 2016

Hi use sub-query with left join

Answer Question  Select Best Answer

Lesley Ruzvidzo

• Nov 3rd, 2016

Theta join combines tubles from different tables(relation) provided they satisfy the theta condition.
Given R1(A1,A2,A3,...,An) and R2(B1,B2,B3,...,Bn) such that they have no common attributes i.e
R1 intersection R2 (R1 n R2) = Theta.
Theta can use all kinds of comparisons like =,>,< ...e.t.c.

sivaprasad

• Apr 10th, 2015

Theta join is nothing but not equi join, i.e.,it is a principle to join two tables with out any common column of both tables.

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

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

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

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

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

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

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 `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

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

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

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

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

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

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