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
- 6796 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 will you make an attribute not process? : sql server analysis services, ssas
Explain what is scheduled job and how to create it?
Explain the ways to controlling cursor behavior?
Explain the flow of creating a cube? : sql server analysis services, ssas
What are secondary xml indexes?
How do I start sql server?
Do you know what is a linked server in sql server?
Can you explain powershell included in sql server 2008?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
How to download and install the scaled-down database adventureworkslt?
Explain various data region available in ssrs with their use?
What is a unique index?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Can primary key be a foreign key?
What are ddl triggers and types of ddl trigger?
