difference between select column name from table name where serviceid=2; and s

difference between select column name from table name where
serviceid=2; and select max(column name) from table name
where serviceid=2;
IN ORACLE

Question Posted / ujjwal.kr22

3 Answers
8223 Views
Intel, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

difference between select column name from table name where serviceid=2; and select max(column nam..

Answer / nishadks

Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int

Values:('AAA',2),('BBB',2),('CCC',2),('DDD',2)

ANS:
select column name from table name where
serviceid=2
ANS:
Column_name
----------------------
AAA
BBB
CCC
DDD

select max(column name) from table name
where serviceid=2;
ANS:
-------
DDD

Is This Answer Correct ?

19 Yes

2 No

difference between select column name from table name where serviceid=2; and select max(column nam..

Answer / raghu

Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int

Values:('AAA',2),('BBB',2),('CCC',2),('DDD',2)

ANS:
select column name from table name where
serviceid=2
ANS:

Column_name
----------------------
AAA
BBB
CCC
DDD
select max(column name) from table name
where serviceid=2;

ANS:
-------
AAA

Is This Answer Correct ?

2 Yes

2 No

difference between select column name from table name where serviceid=2; and select max(column nam..

Answer / manish

Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int

Values:('Z',2),('Y',2),('B',2),('C',2)

ANS:
select column name from table name where
serviceid=2
Will be 'C'

ANS:
select max(column name) from table name
where serviceid=2;
Will Be 'Z'

Is This Answer Correct ?

3 Yes

13 No

Post New Answer