Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

column A column b | output
10 7 | 10
5 8 | 8
7 -9 | 7
3 5 | 5
0 6 | 6

Write a sql query to print such output.

Answer Posted / suresh ramsng

select A,B,greatest(A,B) output from <tablename>

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1078


How many joins in sql?

1055


Mention what does plv msg allows you to do?

1161


What is difference between sql function and stored procedure?

1063


What is the meaning of disabling a trigger?

1236


Why is pl sql needed?

1004


What is the difference between microsoft access and sql server?

1105


how to rename an existing column in a table? : Sql dba

1079


What is a recursive stored procedure?

1253


what is bdb (berkeleydb)? : Sql dba

1090


What are the advantages of normalization?

1129


How is data stored in sql?

1101


What is a design view?

978


what are wild cards used in database for pattern matching ? : Sql dba

1204


What plvcmt and plvrb does in pl/sql?

1366