difference between select column name from table name where
serviceid=2; and select max(column name) from table name
where serviceid=2;
IN ORACLE
- 3 Answers
- 7396 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
What is 2nf example?
What is replication with database mirroring? : sql server database administration
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Is sql server free?
Explain what is the difference between union and union all?
What to check if a User database is locked?
Name and describe few console utilities for ssrs?
What are the types of user defined functions in sql server?
What is query optimization process?
What is not null constraint?
Explain transaction server isolation?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What are policy management terms?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is the difference between resultset and resultsetmetadata?
