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
8241 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 important architecture components of SSRS?

140

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1607

What is the osql utility?

975

What are the indexes in sql server?

1115

What is full outer join in sql server joins?

1068

What are the common performance issues in sql server?

928

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137

What is an example of a foreign key?

975

Explain what are sparse columns?

993

Find first and last day of current month in sql server

1028

What is the difference between lock, block and deadlock? : sql server database administration

1047

what are the disadvantages of cursors? : Sql server database administration

1029

What is use of dbcc commands?

1073

What is normalization? Explain its different types?

1092

How to automatically create a log when an exception is being received into SQL Server?

1289