Answer Posted / sandipan sinha
if I am in need to see the data set in a tabular format
where for each column entry in primary key we can have more
than one entries in other columns,ssometimes they are
needed to be added and summed up together.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what are all the different normalizations? : Sql dba
what is an alias command? : Sql dba
What is denormalization in a database?
What is a join?
What is coalesce in sql?
What is sql dialect?
which tcp/ip port does sql server run on? : Sql dba
Enlist the characteristics of pl/sql?
What found sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What are the advantages of indexing?
what is the different between now() and current_date()? : Sql dba
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Does group by remove duplicates?
What are analytical functions in sql?
