can any one please send sql quries most used in applications.
Answers were Sorted based on User's Feedback
Answer / guest
select * from employee
where sal =
(select * from max(sal) from emp)
| Is This Answer Correct ? | 3 Yes | 3 No |
What is partition in sql server?
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?
Can a rule be bound to any column of any data type?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is difference between equi join and natural join?
What are the two authentication modes in sql server?
what's the difference between SQL & MY-SQl...? And what we learn from these ....?
What is the recursive stored procedure in sql server?
Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is join and name different type of joins?
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)