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
- 8099 Views
- Intel, Wipro, I also Faced
- E-Mail Answers
Answer Posted / nishadks
Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int
Values:('AAA',2),('BBB',2),('CCC',2),('DDD',2)
ANS:
select column name from table name where
serviceid=2
ANS:
Column_name
----------------------
AAA
BBB
CCC
DDD
select max(column name) from table name
where serviceid=2;
ANS:
-------
DDD
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
How to use subqueries in the from clause in ms sql server?
How to locate and take substrings with charindex() and substring() functions?
What is the difference between implicit and explicit transaction?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Define Wed Edition in SQL Azure?
How to Sync Two SQL Azure Databases?
What is bcp? When does it use?
What is the use of =,==,=== operators?
what types of replication are supported in sql server? : Sql server database administration
Can a database be shrunk with users active?
How to replace given values with null using nullif()?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Suggest a method of joining two tables.
what does the automatic recovery do? : Sql server administration
What are the different kinds of ssrs reports?
