what is the difference between rownum pseudo column and row_number() function? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
what are the different tables present in mysql? : Sql dba
Is sql a scripting language?
what is union, minus and interact commands? : Sql dba
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What does select count (*) mean in sql?
table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678
How many null values can be inserted in a coulmn whihc is unique constraint
What is materialized view in sql?
When can we use the where clause and the having clause?
Is ms sql is free?
What happens when a trigger is associated to a view?
What are inner and outer joins examples of both?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)