What is rank function in sql?

0 Answers  

---

Is sql harder than python?

0 Answers  

---

What is serial sql?

0 Answers  

---

Is sql considered coding?

0 Answers  

---

what is sql? : Sql dba

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

What are code pages ?

1 Answers   BirlaSoft,

---

Can a foreign key have a different name?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

What is sql used for?

0 Answers  

---

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

---