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
- 8377 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 inner join in sql server joins?
Why are sql functions used?
What is the purpose of linked server configuration in sql server?
Can we add a cpu to sql server?
How to connect php with different port numbers?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are the reporting services components?
What are synonyms?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are the differences between ms sql server & oracle?
What type of Index will get created after executing the above statement?
Explain about thread and memory management process of SQL?
What is a sql join?
What is the difference between the 2 operating modes of database mirroring?
