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
- 6792 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 @@rowcount in sql?
Explain about nested stored procedure?
What is the difference between deallocate cursor and close cursor?
What is sql sandbox in sql server?
What is merge statement?
What is your recommendation for a query running very slow? : sql server database administration
What is a field name?
Some queries related to SQL
What is delete query?
Mention the uses of stored procedures.
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to add a new dsn with the odbc driver for sql server?
What is the difference between join and inner join?
What does ss stand for sexually?
If we delete pack Spec what will be the status of pack Body ?
