Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8204 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 a trace frag?
Explain how does the report manager work in ssrs?
What are the 2 types of classifications of constraints in the sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How many types of database relationship in sql server?
What are the different authentication modes in sql server?
What is function of CUBE ?
Tell me what is difference between clustered and non clustered index?
What is the recommended total size of your memory optimized tables?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How would you choose between a clustered and a non-clustered index?
How do you delete a data source?
Can you explain various data region available in ssrs with their use?
What is @@error in sql?
What are the properties of sub-query?
