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
- 7046 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 the system function to get current user's user id? : Sql server database administration
What is clustered vs nonclustered index?
Explain about analysis services?
How to get @@error and @@rowcount at the same time?
What are the two modes of authentication in sql server?
Difference between DELETE and TRUNCATE?
How to disable triggers using "disable trigger"?
When I run the sql server 2000 setup, it just hangs. What do I do?
What are the system database in sql server 2005?
Explain different types of Normalization.
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
can you implement data mining in SSRS?
Explain what is the use of custom fields in report?
What is openxml in sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
