How can u find column name from a table which have max value
in a row.( not max value)
Answer Posted / ajit
SELECT COUNT(Sal), COUNT(Comm)
FROM Emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of a subquery?
Can a composite key be null?
What is the difference between syntax error and runtime error?
How do I turn a list into a table?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Explain the difference in execution of triggers and stored procedures?
Mention what does the hierarchical profiler does?
What schema means?
What are triggers in sql?
What is mdb stand for?
Is join an inner join?
what is a cursor? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Why do we create views in sql?
What is sql mysql pl sql oracle?