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
- 8042 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
What is the difference between mysql and mysqli?
What are the benefits of filtered indexes?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is attribute? : sql server analysis services, ssas
How to find the version of sql server? : sql server database administration
How to use the inserted and deleted pseudo tables?
what stored procedure would you use to view lock information? : Sql server administration
Does sql server use java?
What happens if null values are involved in string operations?
What is the sql case statement used for?
How to generate create table script on an existing table in ms sql server?
what types of replication are supported in sql server? : Sql server database administration
How to list all objects in a given schema?
What are the types of dml?
What is a virtual table in sql?
