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
- 7395 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
Explain about SQLOS?
How can you set the threshold at which sql server will generate keysets asynchronously?
What's the information that can be stored inside a bit column?
What is the query and subquery?
What is report server project?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Explain the properties of a relational table?
What is subquery explain with example?
What is self contained sub query?
What is snapshot parameter in ssrs?
What is transaction server isolation?
List some advantages and disadvantages of stored procedure?
What is system stored procedures?
What are the grouping functions?
Differentiate between sql temp table vs table variable?
