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
- 8040 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 traditional network library for sql servers? : Sql server database administration
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is row_number function?
How to create and drop temp table in sql server?
Explain about protocol layer present in SQL server?
Do you know what is normalization of database? What are its benefits?
What is use of @@ spid in sql server?
How to identify current user in ssrs report?
what are the important architecture components of SSRS?
What is failover clustering overview?
What do you understand by mirroring and mention the advantages of the mirroring?
What is policy based management (pbm)? : sql server database administration
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Why union all is faster than union?
Explain rdbms?
