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

krishsidd

 Profile Answers by krishsidd Questions by krishsidd

• Nov 26th, 2010

Space included in name in answer submitted by ashishkumar2403
select Rpad(rpad(Substr('Steven Kovy',INSTR('Steven Kovy',' ')+1), length(Substr('Steven Kovy',INSTR('Steven Kovy',' ')+1))+1,' ' ), length('Steven Kovy'),substr('Steven Kovy',1,instr('Steven Kovy',' '))) xfrom dual;

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Nov 23rd, 2010

  1* select rpad(lpad('Steven Kovy',(length('Steven Kovy') +1),''''),length('Steven Kovy')+2,'''')  Name  from dualSQL> /NAME-------------'Steven Kovy'

Answer Question  Select Best Answer

emraan

 Profile Answers by emraan Questions by emraan

• Dec 29th, 2009

Select * from emp where substr(ename, -1) = 'S'Thanks & Regrads

goutamgeek

 Profile Answers by goutamgeek Questions by goutamgeek

• Dec 23rd, 2009

select * from table_name where substr(first_name,length(first_name),1)='S'

Answer Question  Select Best Answer

shital Rathod

• Nov 24th, 2021

This solution best in oracle ,but decode () is not work in mysql.
can you take in mysql and giv me the proper query regarding this question.

Mercy

• Oct 29th, 2018

Hope the below query will answer the question."sql SELECT COUNT(*) total, SUM(decode(to_char(hire_date,yyyy),1995,1,0)) "1995", SUM(decode(to_char(hire_date,yyyy),1996,1,0)) "199...

Answer Question  Select Best Answer

katgeektalk

 Profile Answers by katgeektalk Questions by katgeektalk

• Aug 26th, 2010

Select hiredate,  to_char(hiredate, 'Day')  "DAY OF THE WEEK"from scott.emporder by to_char(hiredate-1, 'D')

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Mar 22nd, 2010

Select to_char(hire_date, 'day')from table_nameorder by to_char(hire_date -1 ,'day');RegardsDharmendra Jaiswal

Answer Question  Select Best Answer

Bibhudatta Pand

• Jun 18th, 2019

Suppose below is the city table contains NAME SEX Bangalore FEMALE Bangalore MALE Bangalore MALE Bangalore FEMALE Bangalore MALE Bangalore MALE Hyderabad MALE Hyderabad MALE Hyderab...

Karthik K Shetty

• Jun 20th, 2016

Code
SELECT (SELECT COUNT(NAME) FROM TABLE_NAME WHERE UPPER(SEX) LIKE M%) AS COUNT_OF_MALE,
           (SELECT COUNT(NAME) FROM TABLE_NAME WHERE UPPER(SEX) LIKE F%) AS COUNT_OF_FEMALE
FROM DUAL;

Answer Question  Select Best Answer

katgeektalk

 Profile Answers by katgeektalk Questions by katgeektalk

• Aug 26th, 2010

If the values in the field comm both NULL and 0 the query should beselect empno, decode(nvl2(comm, to_char(comm), 'N/A'), '0', 'N/A')from scott.empNVL2 to convert NULL value into N/ADecode to convert 0 value into N/A

emraan

 Profile Answers by emraan Questions by emraan

• Dec 29th, 2009

1) SELECT e.*, nvl2(comm, 'Not Null', 'Null') FROM emp e  2) SELECT e.*, decode(comm, '', 'Is Null', 'Is not Null') FROM emp e

Answer Question  Select Best Answer