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
- 8098 Views
- Intel, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manish
Let's Say Struct of Table_Name is
Column_name Varchar, Service_id Int
Values:('Z',2),('Y',2),('B',2),('C',2)
ANS:
select column name from table name where
serviceid=2
Will be 'C'
ANS:
select max(column name) from table name
where serviceid=2;
Will Be 'Z'
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
Does group by sort data?
How to make conditional sum in ssrs?
How many joins in sql server?
How to create a ddl trigger using "create trigger" statements?
How to drop an existing schema in ms sql server?
Explain transaction server implicit?
What is the name of the Database which IBM mainframe uses?
How to link tables in sql server?
What is the security principal at the database level that represents your session?
How do I run a trace in sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What happens if null values are involved in boolean operations?
What is the datatype of rowid?
How can you set the threshold at which sql server will generate keysets asynchronously?
How to convert numeric values to integers in ms sql server?
