Let's Say Struct of Table_Name is Column_name Varchar, Service

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 / raghu

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different types of data sources?

1021

Can you create a logon trigger in sql server 2005 express edition?

1083

What are the types of user defined functions in sql server?

1052

Do you know how to implement service broker?

928

Mention the different types of triggers?

1119

Write a program to fetch first 10 records from a file?

1014

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1012

Can we call stored procedure in trigger?

951

Explain unique key in sql server?

1013

What is resource governor in sql server?

1002

How to get the definition of a view out of the sql server?

987

How to create a new login name in ms sql server?

1066

What are difference between Cluster index and Non-Cluster index?

1081

What are orphan records?

932

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1035