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
- 8036 Views
- Intel, Wipro, I also Faced
- E-Mail Answers
Answer Posted / raghu
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:
-------
AAA
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is an extended stored procedure? : Sql server database administration
What is a heap?
What are information schema views?
What are the acid properties?
What are the three different part of rdl file explain them?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is spatial and temporal data?
How to concatenate two strings in SQL Server.
How can windows applications connect to sql servers via odbc?
How do you use a subquery to find records that exist in one table and do not exist in another?
How would you choose between a clustered and a non-clustered index?
What is a dataset and what are the different types of datasets?
How to start and end transact-sql statements?
What are the different types of sql server replication? : sql server replication
How to execute multiple stored procedures at one time in sql server?
