Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between drop and truncate commands in sql?
- 0 Answers
- 1021 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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
What is an example of translating a date into julian format?
Write one update command to update seqno field of a table on the basis of row number.
Write a query to get last 10 records from the table.
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Are left and right joins the same?
Can a foreign key have a different name?
what are the authentication modes in sql server? : Sql dba
How to place comments in pl/sql?
Can we edit a view in sql?
How to run sql statements with oracle sql developer?
-
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)
