What is the order of sql select?
No Answer is Posted For this Question
Be the First to Post Answer
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
Can we use update in sql function?
Can we perform dml in function?
What is dialect in sql?
Is postgresql a server?
how is exception handling handled in mysql? : Sql dba
What is trigger and types?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
Write a query to find five highest salaries from EMP table. (there is a column SALARY)
24 Answers Cap Gemini, iNautix,
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
What is tuple in sql?
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)