There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10 304 35 25 355 20 40 40write a query to update column maxmarks such that maxmarks column contains whatever be the greater value among marks1...

indra.prasad

 Profile Answers by indra.prasad Questions by indra.prasad

• Jul 12th, 2010

CREATE TABLE aa(name varchar(10), marks1 int, marks2 int, maxmarks int);INSERT INTO aa VALUES ('a',10,20,null);INSERT INTO aa VALUES ('b',20,25,null);UPDATE aa SET maxmarks= CASE WHEN marks1 > marks2 THEN marks1 ELSE marks2 END;

Palash Biswas

 Profile Answers by Palash Biswas Questions by Palash Biswas

• May 20th, 2010

Declare @tbl_Test TABLE([Name] Nvarchar(255),Mark1 int,mark2 int,maxmark int) Insert into @tbl_Test([Name] ,Mark1 ,mark2) VALUES ('a',50,20) Insert into @tbl_Test([Name] ,Mark1 ,mark2) VALUES ('b',10,...

Answer Question  Select Best Answer

Prabhat Sahu

• Oct 21st, 2017

B-Tree Index:
1. Oracle Default index.
2. Cardinality is High, means less duplicate(more unique records) (i.e. Rowid)

Bitmap Index:
1. Cardinality is Low, means more duplicate.(most of the values are repetative)
2. Flag related columns ( i.e. M/F, Y/N, 1/0 )

Vineet

• Oct 12th, 2017

1. B-tree Index has high cardinality values, where as Bitmap Index has low Cardinality values.

Answer Question  Select Best Answer