Write a query to update third column such that
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...
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;
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,...
What is the diff b/w btree index and bitmap index
A B-Tree index stores the index value and the physical rowid of the row. The index values are arranged in the form of leaves. A B-Tree index is used most when the cardinality is high.
A Bitmap index ...
For example suppose we have using many distinct value for particular column in that time using b-tree index.
Bitmap indexes which is used low cardinaties values .
For example suppose we have using gender or flag column in that time using bitmap index .
Describe a time when you had to work under pressure.
How do you handle difficult situations?
How do you deal and overcome major challenges?
What do you do when things do not go as planned? Cite an example.
Importance of an MBA for an entrepreneur
What will you do when you are not able to get your message across to your audience?
Tell me three things about you, which are not found in your resume
Do you like working in a team or alone? Explain.
Has there been a time when you were presented a problem and solved it?
Aptitude Test Preparation Tips
Ask Interview Question?
Have Career Question?
Ask Only Career questions.