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
- 7392 Views
- Intel, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manish
Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int
Values:('Z',2),('Y',2),('B',2),('C',2)
ANS:
select column name from table name where
serviceid=2
Will be 'C'
ANS:
select max(column name) from table name
where serviceid=2;
Will Be 'Z'
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
What is the stuff?
What is an expensive query?
Is there any difference between primary key and unique with the not null condition?
How to view existing indexes on an given table using sp_help?
Does transparent data encryption provide encryption when transmitting data across the network?
Why is replication required on the sql server?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What do you understand by mirroring?
How to enter binary string literals in ms sql server?
What are the benefits of normalization?
Who is the owner of a schema in ms sql server?
How do I install sql server?
where the connection string store in the database
What are the system database in sql server 2005?
How do you open a cluster administrator?
