1. Which is an aggregate function?
a. Union b. like c. max d. Rank
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
What is a system versioned table?
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
Can you have multiple SPs with the same name on a database?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is microsoft t sql?
What is the source code of a program?
What is a dynamic query?
What is the command used to fetch the first 5 characters of a string?
What are the types of triggers in sql?
With out using count() function. How to the find total number of rows in a table?
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)