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
- 8190 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
How to handle error or exception in sql?
Where in ms sql server is ’100’ equal to ‘0’?
What is the significance of null value and why should we avoid permitting null values?
What are the new features in sql server 2016?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How we create SQL Server 2005 Reporting Services ? Give me Sample
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to drop an existing table?
What do you understand by triggers and mention the different types of it?
What does <> symbol mean?
What are the differences between char and nchar in ms sql server?
Define normalisation?
How can you list all the columns in a database?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How would you go about developing a ssrs report?
