difference between select column name from table name where
serviceid=2; and select max(column name) from table name
where serviceid=2;
IN ORACLE
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
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 |
Explain forward - only cursors?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is raid, and how it can influence database performance?
What is the appropriate number of test cases that you can write on a database?
What are ddl triggers and types of ddl trigger?
What is Service Broker in sql server 2012?
Is it important for a database administrator to understand the operating system and file access?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
How to work on DTS?what is the main requirement?
what is create database syntax? : Sql server database administration
What are the different types of backups that exist?