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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different types of upgrades that can be performed in sql server?

1158

What is the difference between count and distinct count?

866

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

934

Difference between 2NF &3NF ?

1069

Describe the functionalities that views support.

1082

Explain nested join?

959

What is the dbcc command and why is it used?

1030

Give me a SQL Query to find out the second largest company?

1147

What are the differences between lost updates and uncommitted dependencies?

1050

What stored by the tempdb ? : sql server database administration

1028

Define a cross join?

988

What to check if a User database is locked?

1049

Tell me the phases a transaction has to undergo?

941

Please explain what is “asynchronous” communication in sql server service broker?

912

When is the use of update_statistics command?

986