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
- 8251 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
Explain foreign key in sql server?
How to create new table with "create table" statements?
Explain about builtinadministrator?
Explain about nested stored procedure?
What are the different types of normalization?
Define compound operators?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Explain the different index configurations a table can have?
What is the difference between left and right outer join?
What Are the Main Features of SQL Azure?
what does the automatic recovery do? : Sql server administration
Explain atomicity?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is difference between getdate and sysdatetime in sql server 2008?
What are the differences between having and where clause.
