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
- 7045 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 modify an existing user defined function?
How do you check sql server is up and running?
What is the stuff?
What is extended stored procedures?
How do you drop an index?
How do you open a cluster administrator?
What are the differences between substr and charindex in sql server.
Which are the important points to note when multilanguage data is stored in a table?
Explain different types of self contained sub query?
Using the customer, and order table in northwind database, please write a query to produce xml?
What is transactional replication?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is ms sql server triggers?
What are the features of Embedded SQL
What happens if an integer is too big for int date type?
