difference between select column name from table name where
serviceid=2; and select max(column name) from table name
where serviceid=2;
IN ORACLE
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
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How can you stop stored procedures from recompiling?
What is report snapshot?
what changed between the previous version of sql server and the current version? : Sql server database administration
What are the different types of backups avaialabe in sql server 2005?
Write a sql query to get zero records from a table having n number of records?
How to rebuild the master database?
How to delete existing rows in a table?
What is difference between oltp and olap?
Can we perform backup restore operation on tempdb? : sql server database administration
How to count duplicated values in a column in ms sql server?
What is data source document?
How to get the query of a table in sql server?
How to round a numeric value to a specific precision?
Explain something about security and SQL Azure?