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
- 6793 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 samples and sample databases are provided by microsoft?
What is blocking and how would you troubleshoot it? : sql server database administration
Can a database be shrunk with users active?
What are some examples of schemas?
What are the lambda triggers?
What are the advantages of policy management?
What is pivot and unpivot?
How to add the custom code in Report?
How to copy data from one table to another table?
What is difference between createstatement and preparedstatement?
What are the recovery models in sql server 2000?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is a with(nolock)?
What are the different SQL Server Versions you have worked on?
What are the advantages of partitioning?
